> I have an application where I want to look for records that match > certain criteria and then for each item found do a second lookup for > additional information. Normally I would do a join. In this case > however I want to display each of the results from the first of the > two criteria whether or not the second part is found or not.
A LEFT JOIN will also include the records in the left table even if there is no corresponding in the 'right' table and fill the empty fields with NULL values. Maybe this is what you're looking for? Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]