- SELECT t1.emp_id, t1.emp_name, t2.dept_name
- FROM employees AS t1 LEFT JOIN departments AS t2
- ON t1.dept_id = t2.dept_id;
| SQL Join Query – MYsql Code |
|---|
|
|
|
SQL Join Query
|
Published: | September 28, 2020 |
Author: | admin |
Category: | SQL Advanced, SQL Source Code |
Views: | 8 |
|
This article was posted in SQL Advanced, SQL Source Code and tagged Exercise SQL Join Query, How to write SQL Join Query, SQL Join Query - SQL Example. Bookmark the permalink. Follow comments with the RSS feed for this post.Post a Comment or leave a trackback: Trackback URL.
|
|
|