>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?
Logical operators are supported in Select-SQL (ie: AND).
Cetin