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 on
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 foun
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 exi
