has N tables, indicating a string "table1","table2","table3"."tableN". The fields of these tables are all the same. Now take out the same fields from these N tables. How should sql write?
select field1,field2
from table1---tableN
this N represents dynamic change, what should I do? Thank you
tables that you cannot write union one by one by hand