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 here.  Is there some way I can get around 2 queries
and do this as one?

-- 
-------------------------------------------------------------
Scott Haneda                                Tel: 415.898.2602
http://www.newgeo.com                       Fax: 313.557.5052
[EMAIL PROTECTED]                            Novato, CA U.S.A.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to