Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to translate this into WHERE condition
Message
From
11/09/2009 17:00:32
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01423733
Message ID:
01423764
Views:
67
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform