Gonkis Posted July 20, 2007 Share 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? Quote Link to comment Share on other sites More sharing options...
Gonkis Posted July 20, 2007 Author Share Posted July 20, 2007 I got it. Had a syntax problem. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.