Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Short quesiotn -- Intersect Operation
Message
De
07/06/2002 00:43:37
 
 
À
06/06/2002 23:46:35
Jimi Lee
Pop Electronic Products Ltd.
Hong Kong, Hong Kong
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00665782
Message ID:
00665789
Vues:
18
This message has been marked as the solution to the initial question of the thread.
>hello everybody,
>
>I have syntax error in the following SQL statement, how should I fix it?
>
>(select distinct cust_code from depositer);
>intersect;
>(select distinct cust_code from borrower)
>
>I just copied the statement from my reference book, does VFP have different syntax when process SQL statement?

VFP does not support the full ANSI SQL syntax, it does not support INTERSECT. You could use a subquery, something like
SELECT DISTINCT cust_code FROM depositer ;
  WHERE depositer.cust_code IN (SELECT DISTINCT cust_code FROM borrower) ;
  ...
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform