How to show the department in output even if it does not any emaployee

Posted by Shubham under Sql Server on 8/1/2012 | Points: 10 | Views : 1598 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

How to show the department in output even if it does not any emaployee ?

Thanks&Regards:-
Shubham Choudhary
Software Engineer
www.facebook.com/shubham.kunar

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Pandians on: 8/1/2012 [Member] [MVP] Silver | Points: 25

0	Check It out! Use LEFT JOIN:- If you have Joined Department and Employee table Select E.Column, D.Column From Department D Left Join Employee E On (D.DeptID = E.DeptID) Go Department Info will be fetched In case if you don;t have Employee info for a department! Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Shubham, if this helps please login to Mark As Answer. \| Alert Moderator

Check It out!

Use LEFT JOIN:- If you have Joined Department and Employee table

Select E.Column, D.Column From Department D Left Join Employee E

On (D.DeptID = E.DeptID)

Go

Department Info will be fetched In case if you don;t have Employee info for a department!

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Shubham, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts

How to get the exact property name while getting error (0)
PDB file is not showing Line Number in dot net application hosted on server (0)
Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different (0)
how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON) (1)
can't receive data after success login ? (1)
Implement Multi-Tenant in Azure Logic Apps (0)
Why ASP.Net Core 7.0 Web API showing as Connection refused? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
More ...