Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to translate this into WHERE condition
Message
De
11/09/2009 17:00:32
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01423733
Message ID:
01423764
Vues:
66
Assuming that "myTable" is some type of Purchases table, wouldn't the second come out to be
  Where not exists(select 1 from my table)
?

>Hi everybody,
>
>I have the following criteria on my form:
>
>Quotes Generated for Manufacturer [         ]            Model         [              ]
>    Exclude Customers who have purchased
>    Exclude Customers who haven't purchased
> Model year from [  ] through [  ]
>
>I'm trying to translate this into where condition.
>
>Exclude customers who have purchased is clear enough:
>
>where not exists (select 1 from myTable where Make = [] and Model = [] and Model year between [] and [])
>
>But how should I translate the second possibility - Exclude Customers who haven't purchased?
>
>Thanks in advance.
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform