Adding AND to JOIN

Databases
1

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

2

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