they are all real tables. Here's the actual coding:

cSelectStat = "select "+lcfields +;
" FROM dride "+;
" left Join dtpprates On dtpprates.ratespk = dride.ratedtppfk "+;
" left Join dtpp On dtpp.tpppk = dtpprates.tppfk "+;
" left Join CRSCHOSEN On CRSCHOSEN.tpppk = dtpp.tpppk "+;
" left Join dpass On dpass.passpk = dride.passfk "+;
" left Join CLIENT On CLIENT.personid = dpass.personidfk "+;
" INTO Cursor crsbilling"

&cSelectStat

Ok, will try this your advice. Thanks.