Last post Oct 15, 2018 06:09 PM by limno
Oct 15, 2018 05:33 PM|labnalstar|LINK
How to combine two table and bring column of both table in a single select statement.
For e.g, I have employee and qualification table
In Employee (empid, empname,salary)
In Qualification (id, qualification, empid)
I want to show all empname, salary, qualification in single select statement.
how to join this table
Oct 15, 2018 06:02 PM|arun899|LINK
You can use inner join for your required output.
Select emp.name,emp.salary,Q.qualification from employee emp
inner join qualification Q.empid=emp.empid
you can refer inner join
Oct 15, 2018 06:09 PM|limno|LINK
Select e.employeename,e.salary,q.qualification from employee e
LEFT join qualification q on q.empid=e.empid