I have a somewhat ugly query I need to perform, that involves selecting values from a many-to-many relationship and using those values in the main query. I could use a loop to populate an array or something, but that would be very taxing on the server machine. I know SQL standards have subquery routines, but I was wondering if MySQL supported subqueries. And if so, if there were anything I should be aware of involving them. Thanks.