S sword_liu Unregistered / Unconfirmed GUEST, unregistred user! 2006-03-06 #2 select distinct * into newtable from oldtable