SQL (this AND that), OR (that AND theOther)

John Craig john at splash21.com
Tue Oct 8 17:34:02 EDT 2013


For clarity, can you post the entire query?


On 08/10/2013 21:52, Roger Eller wrote:
>   Having some SQL query troubles...  I need to get results from a long list
> in a single query, BUT there are pairs of fields that must match.  Every
> pair is a unique pair, aka no duplicates.  If my list contains 50 pair that
> are unique, I may only get 30 returned rows, but I need all 50.
>
> This is what I've tried, but SQL strips away my outer parens, making my AND
> less binding for the pair.
>
> WHERE
>        ((user = 'Joe') AND (car = 'Ford')) OR
>        ((user = 'John') AND (car = 'Chevy')) OR
>        ((user = 'Jim') AND (car = 'Kia')) OR
>        ((user = 'Jim') AND (car = 'Smart'))
>
> ~Roger
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>





More information about the Use-livecode mailing list