Page 1 of 1

if event is in cat query problem

Posted: Mon May 14, 2007 8:15 am
by itsmani1
i want to check if event id is in category id or not?
table structure is like

id
eventid
categoryid


any help?

Posted: Mon May 14, 2007 8:33 am
by CoderGoblin

Code: Select all

SELECT id FROM tablename AS tablea, tablename AS tableb WHERE tablea.categoryid=tableb.eventid