Posted by PW on 10/06/07 13:16

The rs1 sql query is here ...

mySQL = mySQL & "SELECT DISTINCT Qtags.ESCI, Qtags.ESCN, Notes.Notes "
mySQL = mySQL & "FROM QTags LEFT JOIN Notes ON (QTags.ESCI = Notes.ESCI) "
mySQL = mySQL & "ORDER BY Qtags.ESCI "
rs1.open mySQL,myDSN

[Back to original message]