good day, i have read of other problems people facing left joins, not giving correct result , maybe not understanding answers well. here problem having on query select ta.column1 ,d.column2 ,d.column3 ,ta.column4 ,mi.[column5] ,mi.[column6] ,d.[column7] ,d.[column8] ,ta.[column9] ,ta.[column10] ,uc.[column11] ,uc.[column12] ,ta.[column13] ,ta.[column14] ,ta.[column15] ,ta.[column16] ,ta.[column17] ,'0' column18 ,ta.[column19] ,'12.2' column20 ,'none' column21 ,'0' column22 ,'1' column23 ,ta.[column24] ,'0' column25 ,'0' column26 ,ld.column27 [db].[dbo].[table1] ta (nolock) full outer join [db].[dbo].[table2] ld (nolock) on ta.[coulmn1]=ld.[coulmn5] inner join [db].[dbo].[table3] mi (nolock) on ta.coulmn10 = mi.[coulmn3] left join [db...