This is operating as it should. The order of the left joins sets the
precedence of the selection.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 10:55 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: 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
