I need sql query to retrieve a data from different Table

Pnkl

Hello Guys,

I need your help to solve one query for retrieve data like 'ResultTable' from 3 Different Sql Table and Below i give one exmple:

Both Table :Student and Employer Table data insert in to one Table TopicPostTable

Result Table: in TopicPostTable where UserType is 'Emp' then it join with EmployerTable and UserType is 'Stn' then it join with StudentTable

Thanks...

2 Replies

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

Sanjeeb Lenka13y ago
Accepted answer
hi,

try this:

SELECT e.NAME,e.eMail,P.PID
FROM
(SELECT NAME,Email FROM StudentTable
UNION
SELECT NAME,Email FROM EmployerTable)
AS e
INNER JOIN
TopicPostTable p
ON
p.email=e.email
Suresh Babu13y ago
select t.PID,t.Email,e.Name from TopicPosttable t left outer join EmployerTable e on t.PID=e.EID where e.Name is not null
union all select t.PID,t.Email,s.Name from TopicPosttable t left outer join EmployerTable e on t.PID=e.EID left outer join studenttable s on t.Email=s.Email where s.Name is not null