How can I split the data from multiple tables in the return from MySQL
in this example;-
tablea columns = ( uid, a, b, c )
tableb columns = ( uid, d, e, f )
I can get all the related columns like so
select * from tablea left join tableb on tableb.uid=tablea.uid ;
This gives me all the columns but it is not possible to tell from the
resulting associative output which of the tables the columns come
from.
i.e.
uid, a, b, c, uid, d, e, f
1,100, 101,102,1,103,104,105
What I would rather see returned is
tablea.uid, tablea.a, ...
Bookmarks