* Tim McDonough > 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.
Sounds like a job for a LEFT JOIN... if not, why? -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]