资料查询

[danieltang]

表a数据

col1 col2 col3
a a1 a2
a a11 a12
b b1 b2
b b11 b12
....

表b数据
col1 col2 col3 col4
a t1 t2 s1
a t3 t4 s2
b t5 t6 s3

...

求当a.col1=b.col1 and [a.col2,a.clo3]包含于[b.col2,b.clo3]时，a.a2-a.a1-b.s1的一句SQL

[chinaandys]

select * from 表a a join 表b
on a.col1=b.col1 and
exists ((select a.col2 union all a.col3) in (select b.col2 union all b.col3))


a.a2-a.a1-b.s1 ?

[chiwei]

感觉有点乱!
看不明白!

[danieltang]

求a.a2-a.a1-b.s1的值

[davytao1018]

select a.col3-a.col2-b.col4 from 表A a，表B b where a.coll=b.coll and
(select col2,col3 from 表A where in(select col2,col3 from 表B))