如何把sql查询出来的结果当做另一个sql的条件查询

1. — table2 的 name 作为 table1的条件

   select * from table1 where name in (select name from table2)
2. –如果有多条语句，可以使用字段相加再等于

   select * from table1 where fld1+fld2 in (select fld1+fld2 from table2)
3. –也可以使用INNER JOIN 进行查询
   select a.* from table1 a inner join (select name from table2 group by name) b on a.name=b.name

示例：

select a.原27位码,b.IAH04, * from dynzm1 a
join IAH1 b on a.原27位码=b.IAH04
left join IAM1 c on b
where IAA01 in (82,828)

select c.IAH01,d.新编码,c.IAM09 as 老编码,c.IAM13,c.BBY01,c.IAA01 from IAM1 c inner join (select b.IAH04,a.[27位码] as 新编码 from dynzm4 a
join IAH1 b on a.原27位码=b.IAH04) d on c.IAM09=d.IAH04

update dynzx1 set 耗材编码 = 耗材编码 + ‘_SI’

select c.IAH01,d.耗材编码,c.IAM09 ,c.IAM13,c.BBY01,c.IAA01 from IAM1 c inner join (select b.IAH04,a.[耗材编码] from dynzx1 a
join IAH1 b on a.耗材编码=b.IAH04) d on c.IAM09=d.IAH04

select a.*,b.BBY05 as 名称,b.BBY06 as 规格,b.BBE02 as 生产商,b.BBY05 as 名称,b.BBY04 as HIS中可查询编码,b.BBY08 as 单位,b.BBY25 as 单价,b.BBY30 as 创建时间 from nzm2022 a
join BBY1 b on a.BBY01=b.BBY01

转载请注明：落伍老站长 » 如何把sql查询出来的结果当做另一个sql的条件查询