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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
