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.
Creators and Objects table have foreign key relationship by Creator ID, such as: Creators table Creator ID, Creator Name Objects table Object ID, Object Name, Creator ID Thanks for any assistance. Warmest regards, Peter Sawczynec Technology Dir. Sun-code.com Web related services 646.316.3678 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
_______________________________________________ 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
