Omnis Studio 4.3 MySql query syntax for more than one value

David Walton omuser at charlie.housing.admin.nyu.edu
Thu May 29 08:48:37 EDT 2008


In short, yes it is possible. Without knowing your table structure, it  
becomes more difficult. ;-)

On May 29, 2008, at 8: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
>




More information about the omnisdev-en mailing list