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...