The second fuller query worked with a few more qaualifiers that were needed in the WHERE. Thank you very much.
Peter -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carlos A Hoyos Sent: Saturday, June 02, 2007 1:07 PM To: MySQL SIG Subject: Re: [mysql] SELECY QUERY ASSIST > 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 _______________________________________________ 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
