sorry it end up with ". its just for illustration purposes.

cSelectStat = "select "+lcfields +;
" FROM a "+;
" left Join b On b.fieldpk = a.fieldfk "+;
" left Join c On c.fieldpk = b.fieldpk "+;
" left Join d On d.fieldpk = c.fieldpk "+;
" left Join e On e.fieldpk = d.fieldpk "+;
" left Join f On f.fieldid = e.fieldpk "

&cSelectStat into cursor curtemp readwrite
select curtemp