Can anyone see why this left join isn't working?
select notifications.id, notifications.status, notifications."receiverId", notifications."notificationObjectId"
from
notifications
left join
"notificationObjects" on notifications."notificationObjectId" = "notificationObjects".id;select notifications.id, notifications.status, notifications."receiverId", notifications."notificationObjectId"
from
notifications
left join
"notificationObjects" on notifications."notificationObjectId" = "notificationObjects".id;