Hi there,
I have a many-to-many relationship: ind table --------- id = 4, name = Joe id = 5, name = Jane bus_ctr table ------------- id = 1, name = downtown mall id = 2, name = sunshine mall id = 3, name = express shop mm_ind_bus_ctr table (many to many association table) ----------------------------------------------------- id = 6, ind_id = 4, bus_ctr_id = 1 id = 7, ind_id = 4, bus_ctr_id = 2 id = 8, ind_id = 4, bus_ctr_id = 3 id = 9, ind_id = 5, bus_ctr_id = 1 Is there a way to create a SELECT that returns only the people in the ind table that are associated with bus_ctr.id=1, bus_ctr.id=2 and bus_ctr.id=3? In other words a SELECT that only returns the ind.id = 4 (Joe) record? I've only been able to create a SELECT that would return both Jane and Joe so far. Thanks, Joe --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php