Post reply

How to write for this scenario

  • March 27, 2006 at 8:29 am

    #112559

    I ahve 3 tables employee(EmpID,name),department(DeptID,DeptName) and employeedepartment(EmpID,

    DeptID).

    I need to show all department names and their employee names.Example

    Production James

    Production Kapil

    Commerce NULL

    Finance Jack

    thks

  • March 27, 2006 at 9:25 am

    #628959

    Select

    D.DeptName, E.Name

    From

    department D

    Left

    Outer Join employeedepartment ED

    ON

    ED.DeptID = D.DeptID

    Left

    Outer Join employee E

    On

    E.EmpID = ED.EmpID

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply