Hi, You only want one result set, so you should perform only one query. You know the AND operator, what you also need is the OR operator and some parentheses. Try something along these lines:
... WHERE (field1=val1 AND field2=val2) OR (field1=val3 AND field2=val4) ...
:)
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
