Hey Charlie, Try this SELECT * FROM maintable where Owner IN(2,3,4) or Contact IN(2,3,4) or AccountsContact IN(2,3,4) ORDER BY DomainName ASC;
On Thu, May 22, 2008 at 12:37 PM, Charlie Markwick <[EMAIL PROTECTED]> wrote: > 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 > > -- A.M.Doctor [Non-text portions of this message have been removed]
