I want to do the following: 1-If table x exists, then drop. 2-then, create table x again.
Explanation: Table x in (1) has different date parameters than table x in (2). They are called the same name because there is a function that uses that table. Basically, I want to do something like: DROP TABLE IF EXISTS ExistingDocID CREATE TABLE ExistingDocID SELECT distinct OrderingPhysicianID FROM vu_StudyInformation WHERE StartDate Between '1999-11-25' and '2002-05-01' ORDER BY OrderingPhysicianID asc Any ideas? <sql, query> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php