General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SPT using Multiple Join Conditions
Environment versions
Network:
Windows 2000 Server
I have this SPT string that works as long as the drawmext3 table has only one match to the drawmstrp table:
getDrawingDataString = "Select * From drawmstrp Left Outer Join drawmext1 On drawmstrp.dm_drawing_number = drawmext1.dmdrawno Left Outer Join drawmext3 On drawmstrp.dm_drawing_number = drawmext3.dmdrawno Where drawmstrp.dmdrawno = '" + PadR(whatDrawingNumber,12) + "'"
drawmstrp = header data of Engineering Drawing Numbers
drawmext3 = detail changes of drawmstrp
However, if drawmext3 has several records that match the drawmstrp my SPT will pull the first record data.
How can I have the ON(join condition) look at more than one field to match on and at the same time still pull from the drawmstrp table if no matches are found?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only