What is the correct way to order the sequence join statements?
Device is the table driving this example join... it has foreign keys to the tables part and traveler.
FROM Device, Part, Traveler
Where Lot = 'LotID'
AND Part.Part_ID = Device.Part_ID
AND Traveler.Traveler_ID = Device.Traveler_ID
-OR- do you turn around the Joins like this?
AND Device.Part_ID = Part.Part_ID
AND Device.Traveler_ID = Traveler.Traveler_ID
thanks for the advice.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2002-02-16 04:38:30|
|Subject: Re: join question |
|Previous:||From: Francisco Reyes||Date: 2002-02-15 21:03:42|
|Subject: Re: Upgrading to 7.2 |