Information générale
Titre:
SQL Select - WHERE clause VS JOIN clause to join tables??
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement