SQL Help

• VT-176769

  SSChasing Mays

  Points: 637

  More actions

  March 10, 2005 at 5:30 am

  #362224

   Hi all,

  What I want is a single SQL Statement, if possible,

  Table bellow is a result of 3 differnet select, Now, i want to join to 3 other tables. if EMPLOYEEID   is not null then link it to E__EMPLOYEE, if  SUPPLIERID   is not null then to S_ORGANISATION and so on..How do i do it ? Help pls

  TENANCYID   SUPPLIERID  EMPLOYEEID  TABLENAME     

  ----------- ----------- ----------- --------------

  NULL        NULL        34          E__EMPLOYEE

  NULL        NULL        97          E__EMPLOYEE

  NULL        NULL        105         E__EMPLOYEE

  NULL        3           NULL        S_ORGANISATION

  NULL        31          NULL        S_ORGANISATION

  NULL        147         NULL        S_ORGANISATION

  NULL        330         NULL        S_ORGANISATION

  NULL        395         NULL        S_ORGANISATION

  270393      NULL        NULL        C_TENANCY

  866385      NULL        NULL        C_TENANCY

  970469      NULL        NULL        C_TENANCY

  970597      NULL        NULL        C_TENANCY

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  March 10, 2005 at 7:19 am

  #546362

  Duplicate post.

  See http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=166820

  Far away is close at hand in the images of elsewhere.
  Anon.