Forum Discussion
How to convert from Table to separate query
Hi Team,
I have more than 40 tables in a single query, I have to separate each table into new query. I don't want to duplicate the query and expand, as I said currently I have 40 tables it may increase in future. Is there a way or script avaialble to convert this into separate queries. Please have a look at screen shot below. amitchandak Greg_Deckler FreemanZ lbendlin
1 Reply
No, but if the tables have the same-ish structure you can create a single query that appends them all (with table name as a column too, if you want). This will work no matter how many tables you will have.
