Re: Getting around 2 queries

[Chuck Gadd]

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 whether rows are found in one table
> or both. You wouldn't know which table though (but from your message, I
> guess that is unimportant).

If you needed to know which table it came from, you could just
expand this query a little:

Select serial,'blacklist ' as Tablename from blacklist where serial = x
Union
Select serial,'seriallist' as Tablename from seriallist where serial = x