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.
SELECT *
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.
Brian
