Initializing SQL database...
Back to Questions
Join employees with departments #7
mediumShow employee_name with their dept_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
employees
employees information
idnameref_id
departments
departments 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