i want to check if event id is in category id or not?
table structure is like
id
eventid
categoryid
any help?
if event is in cat query problem
Moderator: General Moderators
- CoderGoblin
- DevNet Resident
- Posts: 1425
- Joined: Tue Mar 16, 2004 10:03 am
- Location: Aachen, Germany
Code: Select all
SELECT id FROM tablename AS tablea, tablename AS tableb WHERE tablea.categoryid=tableb.eventid