mysql - Getting values from different tables with identical columns into an array -

my sql-request looks this

select objects.name, elements.name, labels.name.... 

i write values request array, this:

while([results next]){  [arrayobjects addobject:[results stringforcolumn:@"objects.name"]];     [arrayelements addobject:[results stringforcolumn:@"elements.name"]];     [arraylabels addobject:[results stringforcolumn:@"labels.name"]];       ...  } 

i see message: "warning: not find column named 'objects.name'"

but if write

while([results next]){  [arrayobjects addobject:[results stringforcolumn:@"name"]];     [arrayelements addobject:[results stringforcolumn:@"name"]];     [arraylabels addobject:[results stringforcolumn:@"name"]];       ...  } 

then have last value arrays.

is there way fix this?

here's try, i'm not sure if looking for:

instead of each column using "same name" this: "select objects.name, elements.name, labels.name...."

try this: "select objects.name o_name, elements.name e_name, labels.name l_name ...."

then, can use unique column names:

[arrayobjects addobject:[results stringforcolumn:@"o_name"]]; [arrayelements addobject:[results stringforcolumn:@"e_name"]]; [arraylabels addobject:[results stringforcolumn:@"l_name"]];   ...