Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need Help with SQL Statement
Message
De
20/09/1997 10:25:12
 
 
À
20/09/1997 01:03:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00050724
Message ID:
00050901
Vues:
43
>I pointed out earlier you don' t need two statements. I think the original question was how to do it with one SELECT.
>
>Hope this helps.
>
>SELECT * FROM Quotes WHERE ;
> DTOC(Date)+Customer IN ;
> (SELECT MAX(DTOC(Date))+Customer FROM Quotes)

Yes, but you still have two SQL-SELECTs (even if one is embeded). Still, yours should be faster than 2 separate SELECTs.

Vlad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform