Column Names on Joined Select

[i3bargon]

I have a couple tables in my database that have a column named "name". When i do a join on these tables how can i specify which name column i want to output. To clarify i want to get the name column from each table but after i retrieved it from the database how can i specify which one im trying to ouput

Example

$sql = "SELECT * FROM table1,table2,table3"
$result = mysql_query($sql)
$obj = mysql_fetch_object($result)

// I would like to output the name column from table1
echo $obj->name;

// I would like to output the name column from table2
echo $obj->name;

// I would like to output the name column from table3
echo $obj->name;

I probably should of done a better design so i wouldnt of ran into this problem, but its too late to fix that. Any suggestions?

Thanks in advance.

[lurius]

select table1.name as name1, table2.name as name2, table3.name as name3 from table1, table2, table3

-Lurius

[i3bargon]

There a quite a bit of other columns that i would like to select. Would i have to name them also, i dont have any naming conflicts with them. For instance besides the "name" column i have about 12 columns in each of the other tables that dont conflict with each other but i would like to stay away from giving those columns an alias on my select.

Thanks for your help.

[lurius]

"Would i have to name them also?"

No.

-Lurius