sql query (in access vs sql7)

[Guest_imported]

i have this in sql7:

tablea
fielda1,fielda2
tableb
fieldb1,fieldb2
tablec
fieldc1,fieldc2

select tablea.fielda1,tablea.fielda2,tableb.fieldb1,tableb.fieldb2,
tablac.fieldc1,tablec.fieldc2
from tablea,tableb,tablec
where tablea.fielda1 = tableb.fieldb1
and tablea.fielda1 *= tablec.fieldc1

how can do the same in vb for access97


thank´s for all

 

[MLK]

Try this:


"SELECT tablea.fielda1, tablea.fielda2, tableb.fieldb1, tableb.fieldb2, tablec.fieldc1, tablec.fieldc2
FROM (tablea INNER JOIN tableb ON tablea.fielda1 = tableb.fieldb1) INNER JOIN tablec ON tablea.fielda1 = tablec.fieldc1;"
Good Luck MLK