Select from multiple tables

1

I know Dremio supports queries like this,

SELECT count(*) 
FROM table_a, table_b, table_c

But I’m looking to retrieve a whole month of data, like table_0901, table_0902, … , table_0930
so is there a way to do

SELECT count(*)
FROM table_09*

I tried but it gave me this error: Table_09* not found.
Please advise.

2

@xinxy220

Currently we do not support wild cards on table names

Thanks
Bali