Union, Left Join, ????

[sdscuba]

Frustrated newbie..... searched for examples and still have not been able to get the results needed.

 

Basically I have these two tables…..

 

eventbooking_bookings

id, applicant_id, event_id

 

eventbooking_events

id, calendarid, dt

 

I need to select dt when searching for an applicant_id from bookings

where

eventbooking_events.id = eventbooking_bookings.event_id

and

eventbooking_events.dt is greater than today

and

eventbooking_events.calendarid = 1

 

Any help would be greatly appreciated.

 

Greg.

[gizmola]

Based on your description something like this should work:

 

select b.*, e.*
FROM eventbooking_bookings e
JOIN eventbooking_events b ON e.id = b.event_id 
AND b.applicant_id = {whatever applicant id}
AND e.calendarid = 1 
AND e.dt > NOW()

[sdscuba]

Had to make a few edits, but it works as needed.  THANK YOU!!!! THANK YOU!!!!

 

select b.*, e.*

FROM eventbooking_bookings e

JOIN eventbooking_events b ON e.event_id = b.id

AND e.applicant_id = 168

AND b.calendarid = 1

AND b.dt > NOW()