List for SQL questions?

Anyone knows a list for discussion SQL questions? On the off chance that this *is* an appropriate list here goes: I want to select tickets from two tables that registers support tickets and events related to the ticket. No problem. Tickets go through various stages, REGISTERED, OPEN, CLOSED in events one ticket can have several entries with one of all three stages on each row. And can have a technician assigned (field gives username) or be not yet assigned to someone (Not Assigned). Now, I want to select ONLY the ticket that meets Registered *AND* Not Assigned. And this should be the final status of the ticket. (All tickets may have this status at one time or another). I've tried: "SELECT ticket.t_id, t_client, t_summary, e_assignedto, e_status FROM ticket, events WHERE e_status = 'REGISTERED' AND e_assignedto = 'Not Assigned' AND ticket.t_id = events.t_id"; This gives me ALL hits on this string. Including tickets that have had the desired status but is now assigned to someone. Any suggestions? I'm using MySQL as a database. Apologies if this is an unappropriate list - and grateful for pointers to the correct forum. M.