SQL Join help

[gte806e]

I have two tables one for events and one for dates.

Events colums: id, event_title, event_copy
Dates colums: id, parent_id, date

I'm trying to pull the event title and date for all events for an entire month.

How would I write a compound sql statment to do this? I know i'd us a join but i'm unclear on the syntax to do this.

Oh yes, one other question:

My date field is of type "date" so how would I be able to pull dates only for certain month by just passing it like a month / year value?

Thanks,

Jesse

[LordShryku]

http://www.mysql.com/doc/en/Date_and_time_functions.html

Something like this

SELECT e.event_id,
       d.date
  FROM events e, dates d
 WHERE e.id = d.id
   AND month(d.date) = 2;