Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some Help with Select statement
Message
 
To
19/09/2003 09:26:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00830332
Message ID:
00830653
Views:
21
>>Hi Kevin,
>>
>>>... the Times AND the Sunday Times and NO other papers.
>>
>>
>> WHERE INLIST(ItemId, ID_SUNDAYTIMES, ID_TIMES); && <-- this is OR
>>   ...
>>
>>
>>Fabio
>
>So it is :-)
>
>
WHERE ItemId = ID_SUNDAYTIMES OR ItemId = ID_TIMES
>
>Thanks for the correction.
>
>Kev
Kev,
Unfortunately that still does and OR not and AND across multiple records which is what I need.
Caroline
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform