I'm pulling data from a mysql database into Excel. The db has about 20 tables, each with identical schemas:

Please Login or Register  to view this content.
I'm able to create a table using query/edit/source/navigation with this code:

Please Login or Register  to view this content.
I've explored the edit/navigation menus hoping to find a way to add new columns from table2, table3 etc. The new columns don't need to show the timestamp but they do need to show Value1 and Value2

It seems that modifying the query would be more efficient than starting from scratch each time, making one db connection for every table I need.

What would be the best way to add columns from these other tables? (and to be clear, these columns would occupy identical rows (dates) in one worksheet.)

Thanks so much!