> I have Creators table and Objects table. > I want to select only Creators that actually have at least one > object row entry in the Objects table.
select distinct creator_id from object ; If you need the id and name, do a straight join and use distinct select distinct c.creator_name, c.creator_id from creators c, objects o where c.creator_id = o.creator_id. Carlos _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
