Getting values from multiple tables
Posted: Tue Aug 23, 2016 3:42 am
Hi,
I am trying to get columns from multiple tables and displaying values in the report. How may i do this?
e.g.
Tables
asset1
asset2
asset3
asset4
.
.
.
asset9999
Note: These tables will keep on increasing.
Currently, I have a query which is able to retrieve all the tables
SHOW TABLES FROM `assetlist` WHERE `assetlist` LIKE 'asset%'
Now my problem is, how do i get the values from all these tables?
I am trying to get columns from multiple tables and displaying values in the report. How may i do this?
e.g.
Tables
asset1
asset2
asset3
asset4
.
.
.
asset9999
Note: These tables will keep on increasing.
Currently, I have a query which is able to retrieve all the tables
SHOW TABLES FROM `assetlist` WHERE `assetlist` LIKE 'asset%'
Now my problem is, how do i get the values from all these tables?