求一句SQL语句，谢谢了

[sean717]

数据表 R_Information R_Send
Apply_ID Apply_ID
Title Dept_Name
Content Flow_State
Info_State
我想要得到的结果就是：
如果用户登陆进来，session("Name")＝Detp_Name 同时符合Flow_State=0,Info_State=1 这些条件的话，那么通过Apply_ID 就可以从R_Information中把相关的那条记录读出来。

[sean717]

BTW，session("Name")=Dept_Name中Dept_Name 是表R_Send里面的

[txlicenhe]

Select a.* from r_information a
join r_send b on a.apply_id = b.apply_id
where b.dept_Name = '姓名'
and b.flow_state = 0
and b.info_state = 1

[pengdali]

select * from R_Information a,R_Send b where a.Apply_ID=b.Apply_ID and Detp_Name=@你的参数 and b.Flow_State=0 and b.Info_State=1

[sean717]

好了，谢谢了，我先试试看，^_^