Hello
I want to fetch record from different table through subquery . Please describe how can we do it through one example?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pankaj Kumar ChoudharyPosted Mar 26, 2015, 9:44 AM
But i can't predict what type of the result you are accepting can you give an example for better understanding your query........
Thanks....
Joginder BangerPosted Mar 26, 2015, 9:19 AM
TableA
id name DepartmentID
1 Davin 1
TableB
DepartmentID DepartmentName
1 Microsoft
select DepartmentName from TableB where DepartmentID(select DepartmentID from TableA where name='Davin')
i think this query may be help you.