As tables within a Dataset do not inherit the Dataset labels, I am looking for ways to label multiple tables.
I think this can be done using Java with a loop but I'm wondering if there's a way to do it using the SQL rather than running it for each table one by one.
I think what you are looking for is how to Query multiple tables and it might also help you to change the labels of the tables.