[Solved] How do I take join on three tables ?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

SQL

I have three tables in the DB , These are EMP_MASTER MBO_MASTER and REPORTING_MASTER,
all these table having EMP_NO as a common field, I want to display all the data of EMP_MASTER for EMP_ID='4000004' on
the basis of MBO_MASTER field MBORQ_ID is equal to 2  for EMP_ID='4000004' and Whose SUP_ID is '12121212' in REPORTING_MASTER

Posted 1-Apr-14 20:23pm

Ni!E$H_WAGH

Updated 1-Apr-14 20:49pm

v2

Add a Solution

Comments

Tom Marvolo Riddle 2-Apr-14 2:29am

Try this:
select * from Emp_master as a inner join MBO_master as b on a.emp_no = b.emp_no inner join reporting_master as c on on a.emp_no = c.emp_no where a.EMP_ID=4000004 and b.MBORQ_ID =2 and c.sup_id =12121212

Tom Marvolo Riddle 2-Apr-14 2:31am

Try it & let me know

Ni!E$H_WAGH 2-Apr-14 2:42am

No it is not working

Tom Marvolo Riddle 2-Apr-14 2:43am

"Not working" - elaborate or post table structures with example records

Ni!E$H_WAGH 2-Apr-14 2:46am

Ohh I am Sorry its my mistake ,it worked Thanks a lot . I took wrong MBORQ_ID .. Thanks again

Tom Marvolo Riddle 2-Apr-14 2:47am

You're most welcome

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tom Marvolo Riddle · Accepted Answer · 2014-04-01T20:47:00

Solution 1

Try this:

SQL

select * from Emp_master as a inner join MBO_master as b on a.emp_no = b.emp_no inner join reporting_master as c on on a.emp_no = c.emp_no where a.EMP_ID=4000004 and b.MBORQ_ID =2 and c.sup_id =12121212

Posted 1-Apr-14 20:47pm

Tom Marvolo Riddle

Updated 1-Apr-14 20:49pm

v3

OriginalGriff · Accepted Answer · 2014-04-01T20:51:00

Solution 2

Try:

SQL

SELECT 
FROM Emp_Master e
JOIN Mbo_Master m 
    ON e.Emp_No=m.Emp_No
JOIN Reporting_Master r 
    ON e.Emp_No=r.Emp_No
WHERE m.EBORQ_ID=2 AND e.EMP_ID='4000004' AND r.SUP_ID='12121212'

Posted 1-Apr-14 20:51pm

OriginalGriff