join one table with two another table

• bkshn

  Right there with Babe

  Points: 794

  More actions

  November 18, 2014 at 11:38 pm

  #397658

  Hello

  I have table A two of its column are ID from another table. for example table B and Table C.

  2 fields in table A

  1.IDB from table B

  2.IDC from table C

  2fields in table B

  1.IDB

  2.NameB

  2fields in table C

  1.IDC

  2.NameC

  I want to right join table A with table B and table C as I have NameB or NameC.

  if IDB isnot exist in Table A, Iwant to don't show nameB as null.

  Could you help me?

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  November 19, 2014 at 1:02 am

  #1759455

  The easiest way for people to understand your requirements, is that you post some sample data and the desired output.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP