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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
