SubQuery的替代查询。 [英] Alternative Query for SubQuery.

问题描述

如何在不使用子查询的情况下编写查询。

How can I write the Query without using Subquery.

Select * from 
(Select A.ContactID, B.CASLOptIN,B.CASLOptOut,B.CASLException From Contact A  inner Join GE_ContactInfo B on A.CONTACTID=B.CONTACTID Where A.Accountid ='XXXXXXXXXX') as Casl 
where(Casl.CASLOptOut ='F' or Casl.CASLEXCEPTION is null) or (Casl.CASLEXCEPTION ='F' or Casl.CASLEXCEPTION is null)

我不想在这种情况下使用SubQuery ....什么可以替代查询。

I dont want to use SubQuery in this case....What can be the Alternative Query for this.

推荐答案

......这样的事情：

... something like this:

SELECT 
 A.ContactID, 
 B.CASLOptIN,
 B.CASLOptOut,
 B.CASLException 
FROM
 Contact A INNER JOIN GE_ContactInfo B 
  ON A.CONTACTID=B.CONTACTID 
WHERE 
 A.Accountid ='XXXXXXXXXX'
AND
(
 (B.CASLOptOut ='F' or B.CASLEXCEPTION is null) 
OR
 (B.CASLEXCEPTION ='F' or B.CASLEXCEPTION is null)
)

希望它有所帮助。

Hope it helps.

这篇关于SubQuery的替代查询。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！