I see how this works when you are pulling fields from a single table, but can this method be used when you are pulling field values from multiple tables?
Here is my current SQL statement:
sql = SELECT abc.no1, abc.no2, abc.no3, efg.no1, efg.no2, efg.no3, lmn.no1, lmn.no2 FROM lmn, efg, abc WHERE (abc.ccustno = efg.ccustno) and (abc.csono = efg.csono)
How can I replicate this sql select statement using the Select Method?
Return to top
Print this page
