Horje Website
SQL Join Query – MYsql Code

SQL Join Query

SQL Join Query - SQL Code


 
  1. SELECT t1.emp_id, t1.emp_name, t2.dept_name
  2. FROM employees AS t1 LEFT JOIN departments AS t2
  3. ON t1.dept_id = t2.dept_id;



Try Your Self ->



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 , , . Bookmark the permalink. Follow comments with the RSS feed for this post.Post a Comment or leave a trackback: Trackback URL.

Leave a Reply

Your email address will not be published. Required fields are marked *

 

Horje © 2011 - 2023