how to create this query

[eluser]kevinprince[/eluser]
Look at active record in the user guide, and look at doing a join rather than a cross table search.