问个SQL语句的问题

Question

两张表
表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语句，谢谢

Answer 1

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

Answer 2

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'

Answer 3

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')

Answer 4

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'