Omnis Studio 4.3 MySql query syntax for more than one value

Dan Ridinger dlr at
Thu May 29 13:49:11 EDT 2008

Hello Peter,

This should give you what yu want

Select Distinct (Customer_id) from article_table where article in  
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?
> Regards
> Peter
> _____________________________________________________________
> Manage your list subscriptions at

Dan Ridinger
Managing Director

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

More information about the omnisdev-en mailing list