Initializing SQL database...
Back to Questions
Join products with categories #79
mediumShow product_name with their category_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
products
products information
idnameref_id
categories
categories 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