Left join not returning missing

SQL++
1

Hi
I have an example query that i’m using but it only returns objectA if a join exists, from my understanding left join should return all objectA’s even if no join exists?

SELECT objectA.*, objectB.fullName as bname
FROM `default` objectA
LEFT JOIN `default` objectB
ON objectA.value = objectB.value
WHERE objectA.type = "objectAType"
and objectB.type = "objectBType"
2

Where clause might be filtering. For LEFT OUTER JOIN, you must move any filters on right side to ON clause.

SELECT objectA.*, objectB.fullName as bname
FROM  `default`  objectA
LEFT JOIN  `default`  objectB
ON objectA.value = objectB.value and objectB.type =  “objectBType”
WHERE objectA.type = “objectAType”;
3

Thank you this worked :slight_smile: