Is there a more concise way of expressing the following select:-

SELECT * FROM maintable where Owner = 2 
or Contact = 2 
or AccountsContact = 2 
or Owner = 3 
or Contact = 3 
or AccountsContact = 3 
or Owner = 4 
or Contact = 4 
or AccountsContact = 4 
ORDER BY DomainName ASC;

Charlie

Reply via email to