Posted by alvonsius on 10/23/05 11:39

Of course when you use SELECT A.name, B.name blah blah you would get
the same column "name" as result (you can try this in console too), so
the best idea is using alias that representing the column like this :

SELECT
A.name AS name_A,
B.name AS name_B
FROM A, B WHERE A.id = B.id

and to access it just use $row['name_A'] ... the variable name still
gave me the information I need

PS: why don't you use LEFT JOIN ??

[Back to original message]