sql select查询问题

[hustent]

我有表proj_info,proj_yearinfo,special_info,我想读取表proj_info中的信息，要求是proj_info.proj_id=proj_yearinfo.proj_id=special_info.proj_info.
请问应该怎么样写这个sql存储过程啊，能写详细点更好，因为我试过in和and，都没有成功。谢谢

[msdnj]

select * from proj_info join proj_yearinfo on proj_info.proj_id=proj_yearinfo.proj_id join special_info on
proj_yearinfo.proj_id=special_info.proj_info

[elite2018]

同上

[syb1045]

[Quote=引用 5 楼 msdnj 的回复:]
select * from proj_info join proj_yearinfo on proj_info.proj_id=proj_yearinfo.proj_id join special_info on
proj_yearinfo.proj_id=special_info.proj_info
[/Quote]
顶了

[阿彪兄]

[Quote=引用 1 楼 jiangshun 的回复:]
SQL codeselect * from proj_info join proj_yearinfo on proj_info.proj_id=proj_yearinfo.proj_id join special_info on
proj_yearinfo.proj_id=special_info.proj_info
[/Quote]
同意

[jiangshun]

select * from proj_info  join proj_yearinfo on proj_info.proj_id=proj_yearinfo.proj_id join special_info on 
proj_yearinfo.proj_id=special_info.proj_info

[「已注销」]

select * from proj_info where proj_info.proj_id=proj_yearinfo.proj_id
INTERSECT     //这个关键字的作用就是找出这2个结果中的交集，就满足你的要求了，试试吧。
select * from proj_info where proj_info.proj_id=special_info.proj_info

[zhangbo6791644]

select * from proj_info
join proj_yearinfo on proj_info.proj_id=proj_yearinfo.proj_id
join special_info on proj_yearinfo.proj_id=special_info.proj_info
你那语句有错误啊