Omnis Studio 4.3 MySql query syntax for more than one value

[Paul Manning]

Might Something like this

Select * from fCustomer where Exists (SELECT fOrder.ID from fOrder  
where fOrder.item=1 Or fOrder.Item=2 Or fOrder.Item=3 and  
fOrder.fCustomer_ID= fCustomer.ID)


Paul


*************************************************
Paul R. Manning
Senior Application Developer
Suran Systems Inc.
Office: 800/633-9581
Fax:  859/873-5763
paul at cdmplus.com
www.cdmplus.com


>
>
>
>> Hello all,
>>
>> Ik am looking for a MySql query that gives me all distinct  
>> customers that have bought article 1 and article 5 and article 8  
>> (at least one of each)
>>
>> The articles I want to check on may differ, and also the number of  
>> articles I want to check. Is this possible?
>>
>> TIA
>>
>> Regards
>>
>> Peter
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>>
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>