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?