In MySQL, I have noticed that you can't create a virtual table by using the following syntax: "select * from (select * from table where agyID=1) where clnID=..." Is this correct? Thanks for your time, Philip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php