mysql extra columns with same name from two tables
Posted
by
salmane
on Stack Overflow
See other posts from Stack Overflow
or by salmane
Published on 2011-01-07T13:47:32Z
Indexed on
2011/01/07
13:54 UTC
Read the original article
Hit count: 126
mysql-query
Table 1 has columns : entry_id user_id ... Table 2 has columns : entry_id user_id ...
the user_id entry is not always the same so I would like to extract both of them so I can later on compare them in my script
SELECT * FROM
table1 as t1
INNER JOIN table2 as t2 on t1.entry_id=t2.entry_id
WHERE t1.user_id='%s'
I would like to extract t1.user_id and t2.user_id ...the problem is the result array has only user_id
thank you
© Stack Overflow or respective owner