jaynesh — 2011-07-11T20:53:31-04:00 — #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
dbPosts.user_id = dbKarma.karma_user_id
r937 — 2011-07-11T21:00:45-04:00 — #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