Loading

how to get the output using inner join query

narasiman rao

9y1k

Employee table as follows

Empid Empname Deptid

1 Raj 1
2 Ram 2
3 Suresh Null
4 Sam 3
5 Vignesh 2

Department table as follows

Deptid Deptname

1 HR
2 Accounts
3 Sales

i want to get output using inner join Empname and Deptid using above two tables Employee and department table

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nazmul Badsha9y ago
1. SELECT Empid,Empname,Deptname
2. FROM Employee
3. INNER JOIN Department ON Department.Deptid = Employee.Deptid
This is the best code.
-1

Tapan Patel9y ago

SELECT Empid,
Empname,
Deptname
FROM Employee
INNER JOIN Department ON Department.Deptid = Employee.Deptid

-1