I could probably help you easily but table structure would be helpful. On Wed, 6 Aug 2003, Merlin wrote: > Hi there, > > I am wondering if this could be done with mysql and without php, just with > sql. > I do have a table with text and another one with pictures. > Now I would like to print out all titles and mark those tests containing a > picture with a camera. > > I tryed some LEFT JOIN stuff, and grouped it by the picture table. Somehow > it returns always yes. > > Has anybody a good idea? > > Merlin > > > > -- Co-Founder Command Prompt, Inc. The wheel's spinning but the hamster's dead -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php