Omnis Studio 4.3 MySql query syntax for more than one value

[Dan Ridinger]

Hello Peter,

This should give you what yu want

Select Distinct (Customer_id) from article_table where article in  
(1,5,8)
group by Customer_id


On May 29, 2008, at 5:20 AM, Peter van Rooij wrote:

> 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

Dan Ridinger
Managing Director

FutureChalk Software Inc.					Phone No:	604.723.6837
20521 92A Avenue						EMail:		dlr at futurechalk.com
Langley, BC  V1M 1B7					www:		www.futurechalk.com