Sub Queries
eharetea

Use sub-queries to perform a query inside of a query.

MySQL subqueries.

Date Created:Friday December 29th, 2006 03:41 AM
Date Modified:Friday August 01st, 2008 11:36 PM

select * from categories where category_id != (select link_id from associations, folders where link_id = folder_id limit 1);

select * from categories where category_id != (select link_id from associations, folders where link_id = folder_id && category_id = 52);