SQLSERVER QUERY

Question

Hello I want to fetch record from different table through subquery . Please describe how can we do it through one example?

Pankaj Kumar Choudhary · Answer

Hello @Davin there a various way for retrieving data from different table . 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 Banger · Answer

try like.... 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.