简单sql语句

[tangyuanjian]

有两个表
plan id,userId
user id,userId,userName
我现在想的到
plan :id ,userName
怎么写sql语句?

[iohui]

能否说清楚一些~
不理解你要做什么

[guan0616]

你可能要这个结果

select a.id,b.username from plan a inner join user b on a.userid=b.userid

[xiaopai__007]

select a.id,b.username from plan a,user b where a.userid=b.userid

[imdosop]

描述问题要清楚

[ysm1850]

select p.id u.userName from plan as p join user as u on(p.id=u.id);

[suxq126]

select a.id,b.username from plan a,user b where a.userid=b.userid(+)

[tautaulee]

select a.id,b.username from plan a inner join user b on a.userid=b.userid

[x03570227]

用join比较好