Here's what I used on the last thing I sent you. You first have to get the primary keys over to the New table so you can compare.
Delete from OldTable Where oldTable.PK Not IN (Select PK from NewTable) You can use IN or NOT IN Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community Get the mailserver that powers this list at http://www.coolfusion.com
