Question

我在此发言。

ProductID     Display       UPC
10            0             0553
14            0             0753
11            1             0753
17            1             0453

如你通知,第2和第3行的《刑事诉讼法》相同。我愿选择显示=0和升值的所有行号,与显示=1的行号相同。因此,我只想选择第2行。这里是我迄今为止的冷聚物法,它不工作。请提出咨询意见。

<cfquery name="GetData" datasource="#Application.ds#" dbtype="ODBC" username="#Application.UserName#" password="#Application.Password#">
Select ProductID, Display, UPC
From Products
Where Display = 0
...
</cfquery>

Answer 1

你们是否寻找正确的问题? 我这样说,实现这一目标的途径不止一个。对我来说,你以我的榜样和我的智慧来做这项工作:

SELECT 
  p1.ProductID, p1.Display, p1.UPC
FROM
  Products as p1, Products as p2
WHERE
  p1.UPC=p2.UPC and p1.Display=0 and p2.Display=1;

Answer 2

使用(图1.)比在使用分电或加入时更高效。

<cfquery name="GetData" datasource="#Application.ds#" dbtype="ODBC" username="#Application.UserName#" password="#Application.Password#">
select ProductID, Display, UPC
from Products p
where Display = 0
and exists (
    select 1 from Products p2
    where p.UPC = p2.UPC
    and p2.Display = 1
)
</cfquery>

Answer 3

以往的回答应当为替代选择工作或去做

<cfquery name="GetData" datasource="#Application.ds#" dbtype="ODBC" username="#Application.UserName#" password="#Application.Password#">
Select t1.ProductID, t1.Display, t1.UPC
From Products t1
Where t1.Display = 0 and
      t1.UPC = (Select t2.UPC 
                  From Products t2
                 Where t2.Display = 1)             
</cfquery>

友情链接