Re: HOW TO search from three tables and get only matches as result

[evan carrish]

Not sure if this is exactly what you're looking for

select a.*, b.*, c.*
from event_wd a
Left Outer Join (events_wd b
Join event_his c On c.weekday = b.weekday)
On a.event_ID = b.event_ID
Where b.weekday = @weekday

I program SQL but mySQL looks very similar so this should work. If not try to tweak it a bit to convert it to mySQL