Select with Left Joins

Perhaps this is obvious, but I have a SELECT (with many LEFT JOINs) that I would expect to return results, but it does not. If I make one change in the order in which tables are used, the SELECT works: The SQL that doesn't work is: --- SELECT T1.patentNumber, T1

Time to be shown with query result

me. However, I'm not sure at all. Thanks for your co-operation in advance. Kenken PA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]