Combine output of select statements on different tables.
I need to generate certain reports. The data has to be taken out from mysql database. But the problem is that the data is scattered over two different tables in a database and the table structure for both the tables is different. The tables do not have similar columns.
But there is a reference from one table to another using a key. Is there a way where in I can run "SELECT" queries on both and combine the result using the common column as key?