Scott Haneda [EMAIL PROTECTED] wrote:
I currently run this, which is 2 hits to the database.
Select serial from blacklist where serial = '23'
Select serial from seriallist where serial = '23'
I only desire to know if either of the 2 has at least one row, I am only
testing for existence
One option would be to 'union' the two queries (assuming the columns are the
same type and length), allowing you to run one query string:
Select serial from blacklist where serial = x
Union
Select serial from seriallist where serial = x
Would return 1 or 2 rows, depending on whether rows are
Matt Chatterley wrote:
One option would be to 'union' the two queries (assuming the columns are the
same type and length), allowing you to run one query string:
Select serial from blacklist where serial = x
Union
Select serial from seriallist where serial = x
Would return 1 or 2 rows, depending