Hi is it possible to add AND to a join query? if so what is the correct method.
Ive tried this but it doesnt work.
LEFT JOIN dbKarma
ON dbPosts.post_id = dbKarma.karma_post_id
AND
dbPosts.user_id = dbKarma.karma_user_id
Hi is it possible to add AND to a join query? if so what is the correct method.
Ive tried this but it doesnt work.
LEFT JOIN dbKarma
ON dbPosts.post_id = dbKarma.karma_post_id
AND
dbPosts.user_id = dbKarma.karma_user_id
there’s nothing wrong with using an AND in the ON clause like that
unfortunately, “doesn’t work” is not enough information for further analysis