Dear,
I need your support i am trying to use full outer join to retrive both table data even matching or not matching but i am getting data only from one table not from another one. Please need your support below are my code and snap from result table1 and table2
SELECT ft.company Table1A, ft.pdqnumber Table1B FROM FinalTest ft full outer join Table2 tb2 on ft.PDQNumber = tb2.PDQNumber and ft.trandate = tb2.TranDate where ft.trandate = '03-Aug-2023' and ft.branch = 'Urth DQ - Riyadh'
Result from above code:
Second Table Result.
I dont know i am trying to put snap but not coming maybe below link will open for yours.if i am explainig.
Second table second columns some more values which is not matching with table1 but not appearing in my above query.
/forums/uploadfile/cbe4a0/09042023173448PM/Second Table.png