寻sql语句多表查询,该如何解决
日期：2014-05-18 浏览次数：20542 次
寻sql语句多表查询
有三个表:
A表字段:title,mobile
B表字段:title,mobile
C表字段:mobile,phone,name
现在的情况是:要从C表中查询出mobile和phone的值并且title=title1并且mobile或者phone的值不在A表和B表的mobile值记录中.
------解决方案--------------------
select mobile into #t from A union select mobile from B
select c.name from C
where c.title = @titel1 and c.mobile not in (select mobile from #t)
and c.phone not in (select mobile from #t)
------解决方案--------------------
有三个表:
A表字段:title,mobile
B表字段:title,mobile
C表字段:mobile,phone,name
现在的情况是:要从C表中查询出mobile和phone的值并且title=title1并且mobile或者phone的值不在A表和B表的mobile值记录中.
------解决方案--------------------
select mobile into #t from A union select mobile from B
select c.name from C
where c.title = @titel1 and c.mobile not in (select mobile from #t)
and c.phone not in (select mobile from #t)
------解决方案--------------------
- SQL code
SELECT c.mobile,c.phone FROM C AS c INNER JOIN A AS a
ON c.mobile=a.mobile INNER JOIN B AS b
ON c.mobile=b.mobile
WHERE a.title=b.title
AND NOT EXISTS (SELECT 1 FROM A WHERE c.mobile=mobile OR c.phone=phone)
AND NOT EXISTS (SELECT 1 FROM B WHERE c.mobile=mobile OR c.phone=phone)
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
