Norman, somehow I just knew that you'd know the answer to this. I appreciate yours and everyone else who responded. That helped. Can someone give me a good source for learning more about how to properly construct queries? What's your favorite reference?
- Ryan Dary Norman Palardy wrote: > > You're probably getting a cartesian product > > Try it with a bunch of subqueries > > SELECT customer.id, firstname, lastname > FROM customer > WHERE customer.id in ( select custid from email where email like '% > 253%' ) > OR customer.id in ( select custid from phone where phone like ) > OR customer.id in ( select custid from address where > street like '%253%' or street2 like like '%253%' or city like '%253%' > or state like '%253%' or zip like like '%253%') _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
