Getting different info from 2 tables in one query

[phpscripters]

Hey,

I want to know if this is possible, because everyone says it is they just don't know how to do it. I have 2 tables, one is $tickets, and one is $ticket_boards... what i want to do would be like this...

I want to get all tickets from $tickets that are in a board $ticket_boards that have public set to 'yes'.

Can I do all that in one query?

Thanks,
Brian

[laserlight]

Probably yes.

You would need to give the database schema, however.