求多表查询语句
表user:
id: 1
name:a
表x:
id: 1 2
user_id: 1 1
x: 56 23
如何查询:name,x呢?
select name,x
from user,x
where user.id=user_id and user.id=1
是否正确?
[解决办法]
select name,x
from user,x
where user.id=x.user_id and user.id=1
少了x.
