Hello,
Basically, i have 2 tables. events and specials.
These are 2 separate tables with no linking elements. I want to grab from both because i want to display a list of the 30 newest events and specials created, sorted by date.
Here is the table structures:
SPECIALS
-------------------------------
id
venue_id
title
more_info
created
EVENT
-------------------------------
id
venue_id
fb_eid
title
date
poster_thumb
poster_large
buy_link
more_info
The only thing these two tables share is the venue_id.
Here is the query:
SELECT * FROM events, specials
WHERE events.venue_id
IN (1,20)
AND specials.venue_id
IN (1,20)
I'm obviously not grasping this concept, or doing something completely wrong, but i can't seem to figure out what.
Can anyone shed any light on this subject?
Thanks!