Inner join and Left Join

P

pol

How I can give Left join, Inner join together in one sql

I have three table

1. Employee, 2. Department . 3. Salary

I need to give

Inner join Employee with Department
Left Join Employee with Department

With Regards
Polachan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To give inner join and Left outer Join 3
two Inner join and leftjoin 2
HELP WITH Access QUERY PLEASE :) 8
to give two inner joins and left join in a query. Please give an e 1
Inner Join works in MDB but not in ACCDB 0
SQL Error when trying to product multi-table query... 3
SQL: Inner Join Works, Left Join Does Not 1
Multi Value Selection issues 4

Top