Hi,

I haven't been using the new JOIN keyword when calling the SQL command. Partly because I still find it a little confusing. Instead I've just been including my joins in the WHERE clause, as in the old days with fox 2.6

I'm wondering if I do use the JOIn keyboard though, if my queries would possibly faster?? Does it have an affect?

And lastly, what would be the equivalant join clause for the following query to join cust & invoice?? inner, left, etc?? I don't know which join is equivalant to the old fox 2.x method and can't find a documentation on it.

select cust.custno, cust.name, invoice.date, invoice.total ;
from cust, invoice ;
where cust.custno = invoice.custno ;
and invoice.date = {06/30/98} ;
into cursor temp

TIA -Rick