I have a query that is similar to the one below. I am trying to get all the records from tableA but the where clause is removing the records. I want the records that do not exists in the table b to be null.
left join tableB on tableB.colB = tableA.colB
group by tableA.colA