I need sql query to retrieve a data from different Table

Question

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:

StudentTable
SID	Name	Email
1	Rohan	[email protected]
2	Ajay	[email protected]

EmployerTable
EID	Name	Email
1	Anna	[email protected]
2	Bittu	[email protected]

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

TopicPostTable
PID	Email	UserType
1	[email protected]	Emp
2	[email protected]	Emp
3	[email protected]	Stn

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

EmplyerTable
PID	Email	Name
1	[email protected]	Anna
2	[email protected]	Bittu
3	[email protected]	Rohan

Thanks...