Here i have two tables
one is Employeedetail consisting (EmpId,Firstname,Lastname,GenderId,Salary) columns and
in the other table i have is tblGender(Id,Gender) consisting Foreignkey relationship.
Here i want to Display Male Records from EmployeeDetail Using Subquery(bu joining Gender colun to the Employeedetail)
i got that by using joins by writing the query as
Select Firstname,Lastname,Salary,Gender from Employeedetail
join tblGender
on Employeedetail.GenderId = tblGender.Id
Where Gender ='Male'
but how to do it using a subquery.
i have tried it something like
Select Firstname,Lastname,Salary,GenderId
From Employeedetail where GenderId in (Select Id from tblGender where Id=1)
but only getting GenderId but i want to display Male & Female instead GenderId Help me Some one