over 4 years ago
Using Inner Join:
It selects rows from both tables as long as there is a match between the column on which join is applied. Inner join is used to fetch data from more than one table.
SELECT columnname(s) FROM tablename1 INNER JOIN tablename2 ON tablename1.columnname=tablename2.columnname;
SELECT Employee.Name, Department.DeptID
INNER JOIN Department
ON Employee. EmpID= Department. EmpID;
It will select those employee name and there respective department IDs whose EmpID in both tables are same.
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
© copyright 2017 FindNerd.com. All rights reserved.
Sign up using