Left join not returning missing

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"

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”;

https://blog.couchbase.com/ansi-join-support-n1ql/

Thank you this worked :slight_smile: