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?