问个SQL语句的问题

[happyzsl]

两张表
表1有
客户－－设备表
cli_name,dev_code,dev_branch
key:以上三个的组合
表2有
设备状态表
dev_code,dev_branch,dev_status
key:dev_code,dev_branch的组合
表1与表2通过dev_code,dev_branch相关

现在想得到cli_name 为 client的所有dev_code,dev_branch唯一标志的设备的状态
输出字段为:
dev_code,dev_branch,dev_status

请问高手，怎么写SQL语句，谢谢

[happyzsl]

很久没用SQL了，都忘了，大家帮帮忙啊

[happyzsl]

急！！！

[大文]

select b.dev_code,b.dev_branch,b.dev_status from tabl1 a,table2 b where a.dev_code=b.dev_code and a.dev_branch=b.dev_branch and a.cli_name='client'

[zhxfzhxf1]

select s.dev_code, s.dev_branch, s.dev_branch
from 设备状态表 as S
where dev_code in (select dev_code from 客户－－设备表 where cli_name='client')

[palmkey]

select b.dev_code,b.dev_branch,b.dev_status from 设备表 a,设备状态表 b where a.dev_code=b.dev_code and a.dev_branch=b.dev_branch and a.cli_name='client'