求个sql语句

[xb12369]

select * from dt_staff where co_id =156 and staff_shouyetuijian =1 limit 0,3

select * from dt_staff where co_id =157 and staff_shouyetuijian =1 limit 0,3

select * from dt_staff where co_id =158 and staff_shouyetuijian =1 limit 0,3

select * from dt_staff where co_id =159 and staff_shouyetuijian =1 limit 0,3

co_id不确定【它还可能是160，161...】，帮我连在一起去！！！

[老猫五号]

select * from dt_staff where co_id IN
(156,160,161)

) and staff_shouyetuijian =1 limit 0,3

[老猫五号]

兄弟，这个问题属于技术版块

[xb12369]

[Quote=引用 1 楼 lhqdyy9 的回复:]
select * from dt_staff where co_id IN
(156,160,161)

) and staff_shouyetuijian =1 limit 0,3
[/Quote]
这是我写的，没用！！
select * from (select * from dt_staff where co_id in
(select co_id from dt_co where co_isstaff = 1) and staff_shouyetuijian =1 limit 0,3 )limit 0,12

报错了！！！
求指教！！
2楼的，我不是要这种！
3楼的，3q!

[老猫五号]

select * from (select * from dt_staff where co_id in
(select co_id from dt_co where co_isstaff = 1) and staff_shouyetuijian =1 limit 0,3 )A limit 0,12

[xb12369]

[Quote=引用 4 楼 lhqdyy9 的回复:]
select * from (select * from dt_staff where co_id in
(select co_id from dt_co where co_isstaff = 1) and staff_shouyetuijian =1 limit 0,3 )A limit 0,12
[/Quote]

哇，我又是死在这个“A”上，
总是不会将查询的结果作为一个整体，然后再取个别名，
服了！！！