Initializing SQL database...
Back to Questions
Join books with authors #120
mediumShow book_title with their author_name. This involves joining multiple tables or using different join types (LEFT JOIN, RIGHT JOIN). Pay attention to which join type is needed based on whether you want to include unmatched rows.
Practice with:
Database Schema
books
books information
idnameref_id
authors
authors information
idname
Expected Output
Click "Show" to see what the correct output should look like.Tip: Try solving it yourself first for better learning!
SQL Editor
Loading...
Press Ctrl+Enter to run query • Start typing for autocomplete