日期:2014-05-18 浏览次数:20386 次
--改下 select p from tb2 t where exists( select 1 from tb1 where g=t.a and h=t.b and j=t.c )
------解决方案--------------------
select b.* from tb1 a,tb2 b where a.g=b.g and a.h=b.h and a.j=b.j
------解决方案--------------------
select b.* from tb1 a,tb2 b where a.a=b.g and a.b=b.h and a.c=b.j
------解决方案--------------------
select b.* from tb1 a join tb2 b on a.g=b.g and a.h=b.h and a.j=b.j