Re: Show user even if gallery is empty

[Phillip Ward]

Little known "trick" with joins:

"LEFT JOIN" + "WHERE" = "INNER JOIN"

Move your gallery condition into the Join clause:

SELECT 
  u.user_uuid
, g.gallery_uuid
, m.gender
FROM members m 
LEFT JOIN users u 
  ON m.user_id = u.user_id
LEFT JOIN gallery g 
  ON m.user_id = g.user_id
 AND g.is_profile_photo = TRUE 
WHERE m.user_id = 1488

Regards, Phill W.