Gonkis 0 Posted July 20, 2007 I am writing a query in SQL to produce the union of 2 tables like this... SELECT [100].*FROM [100]UNION SELECT [300].*FROM [300]; [100] and [300] are the table names. I have 10 tables or so and I want to perform the union on all 10 at the same time to remove any duplicated data between the tables. How to I do this? Anyone with some SQL experience? Share this post Link to post Share on other sites
Gonkis 0 Posted July 20, 2007 I got it. Had a syntax problem. Share this post Link to post Share on other sites