>How can I get this Select statement to work with SPT? I think the syntax needs to be adjusted, but how?
>
>"Select fname, lname, usrid1 From usrtbl Where EXITS (Select * From engschtable Where usrtbl.usrid1 = engschtable.usrid)"
Steve,
It looks OK. However a faster one would be :
"Select fname, lname, usrid1 From usrtbl Where usrid1 in (Select usrid From engschtable)"
or :
lcSQL = "Select u.fname, u.lname, u.usrid1"+;
" From usrtbl u "+;
" inner join engschtable e on u.usrid1 = e.usrid"
Cetin