MySQL 'user_id' in where clause is ambiguous problem
Posted
by HoMe
on Stack Overflow
See other posts from Stack Overflow
or by HoMe
Published on 2010-05-07T11:59:32Z
Indexed on
2010/05/07
12:38 UTC
Read the original article
Hit count: 115
Filed under:
mysql
How can I correct the problem I keep getting from the code below which states 'user_id' in where clause is ambiguous. Thanks for the help in advance.
Here is the mysql table.
SELECT user.*, user_info.*
FROM user
INNER JOIN user_info ON user.user_id = user_info.user_id
WHERE user_id='$user_id'
© Stack Overflow or respective owner
