I am trying to get the metadata info() on a mysql query that does an INNER JOIN, but I am only getting the metadata from the referenced table.

Specifically, in the controller I have $this->view->jobsInfo = $jobs->info();
In the view I vardump $this->jobsInfo['cols']

The query:
SELECT table1.id, table1.customer, table2.category, table2.price
FROM jobs
INNER JOIN table2
ON table1.id = table2.id

Is there a way to get the metadata on table2? Something I should be doing differently?