Good Day,

i have read some of the other problems people are facing with left joins, not giving correct result and maybe i am not understanding all the answers that well.

here is the problem i am having on my 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' AS column18
      ,TA.[column19]
      ,'12.2' AS column20
      ,'None' AS column21
      ,'0' AS column22
      ,'1' AS column23
      ,TA.[column24]
      ,'0' AS column25
      ,'0' AS column26
      ,LD.column27
  FROM [DB].[dbo].[Table1] AS TA WITH (NOLOCK)
  FULL OUTER JOIN 
  [DB].[dbo].[Table2] AS LD WITH (NOLOCK)
  ON
  TA.[coulmn1]=LD.[coulmn5]
  INNER JOIN
  [DB].[dbo].[Table3] AS MI WITH (NOLOCK)
  ON
  TA.coulmn10 = MI.[coulmn3]
  LEFT JOIN
  [DB].[dbo].[Table4] AS D WITH (NOLOCK)
  ON
  TA.coulmn25 = D.coulmn1
  INNER JOIN
  [DB1].[dbo].[Table5] AS UC WITH (NOLOCK)
  ON
  TA.coulmn12 = UC.coulmn3

  WHERE  
  (LD.coulmn5 != TA.[coulmn1])
  AND
  (TA.[coulmn23]= '0')

```

the problem is when i update the query and remove

```
FULL OUTER JOIN 
  [DB].[dbo].[Table2] AS LD WITH (NOLOCK)
  ON
  TA.[coulmn1]=LD.[coulmn5]

```

as well as remove the following where clause:

> 
> 
> ```
>   WHERE  
>   (LD.coulmn5 != TA.[coulmn1])
>   AND
> 
> ```
> 
> 

i have 3 results in my view on the right table. this is correct as the one result has not been written into the left table

when i put back the left outer join and where clause i only see 2 results again, should there not be three results with the last column `,LD.column27` showing as `NULL`.
this column is to accept `NOT NULL` could this be a reason i am not getting the prefered result?