Hi, i am trying to use left outer and right outer join with mail table but i can see some of the record are missing.
i have 3 tables , table A, Table B, Table C.
Id,Name, BID(TableB) CID(TableC) Date
1, Test1 , 2 , 1 , 12-01-2016
2 , Test2 , 3 ,3 , 13-01-2016
3 , Test 3 , 3 ,3 , 14-01-2016
1 , Desc B 1
2 , Desc B2
3 , Desc B3
Table C(Master Table)
1, Desc C1
2 , Desc C2
3, Desc C3
4 , Desc C4
5 , Desc C5
i want get all records from table A and matching record from tableB
with all the record from tableC and matching record from table A
i am using TableA left outer join table B right outer join tableC but some of record are missing from tableC.
please some one help me on this.
now i want to get all the records from tableA