可以编写单个SQL吗？ [英] Can A Single SQL Be Written
问题描述
鉴于：
TblSurveyResponse
SurveyResponseID
ResponderID
SurveyItemID
ResponseYesNo
是否可以编写单个SQL来返回所有已答复的ResponderID是
SurveyItemID 4和否调查ItemID7？
谢谢！
Given:
TblSurveyResponse
SurveyResponseID
ResponderID
SurveyItemID
ResponseYesNo
Can a single SQL be written to return all ResponderIDs who annswered Yes to
SurveyItemID 4 AND No to SurveyItemID 7?
Thanks!
推荐答案
是的，类似于。
从tblSurveyResponse中选择*，其中SurveyItemID = 4且响应=是
和SurveyResponseID in（从tblSurveyResponse选择SurveyResponseID
，其中SurveyItemID = 7且响应=否）
PC数据表" <无**** @ nospam.spam>在消息中写道
news：q _ *************** @ newsread2.news.atl.earthlin k.net ...
yes, something like .
Select * from tblSurveyResponse where SurveyItemID = 4 and Response = Yes
and SurveyResponseID in (Select SurveyResponseID from tblSurveyResponse
where SurveyItemID = 7 and Response = No)
"PC Datasheet" <no****@nospam.spam> wrote in message
news:q_***************@newsread2.news.atl.earthlin k.net...
鉴于：
TblSurveyResponse
SurveyResponseID
ResponderID
SurveyItemID
ResponseYesNo
是否可以编写单个SQL来返回所有回复的响应者ID
到SurveyItemID 4和否到SurveyItemID 7？
谢谢！
Given:
TblSurveyResponse
SurveyResponseID
ResponderID
SurveyItemID
ResponseYesNo
Can a single SQL be written to return all ResponderIDs who annswered Yes
to SurveyItemID 4 AND No to SurveyItemID 7?
Thanks!
John，
感谢您的快速回复！
包含SurveyItemID 9和Response = Yes会是什么样子？ （3
条件）
第四，SurveyItemID 11和回复=否？
感谢帮助!!
" JohnFol" <区************ @ WibbleObbble.Com>在消息中写道
news：k9 ****************** @ newsfe6-win.ntli.net ...
John,
Thanks for the fast response!
What would it look like to include SurveyItemID 9 and Response = Yes? (3
conditions)
And a fourth, SurveyItemID 11 and response = No?
Appreciate the help!!
"JohnFol" <Ou************@WibbleObbble.Com> wrote in message
news:k9******************@newsfe6-win.ntli.net...
是，类似于。
选择*来自tblSurveyResponse，其中SurveyItemID = 4，Response = Yes
和SurveyResponseID in（从TblSurveyResponse中选择SurveyResponseID
，其中SurveyItemID = 7且Response = No ）
PC数据表 <无**** @ nospam.spam>在消息中写道
新闻：q _ *************** @ newsread2.news.atl.earthlin k.net ...
yes, something like .
Select * from tblSurveyResponse where SurveyItemID = 4 and Response = Yes
and SurveyResponseID in (Select SurveyResponseID from tblSurveyResponse
where SurveyItemID = 7 and Response = No)
"PC Datasheet" <no****@nospam.spam> wrote in message
news:q_***************@newsread2.news.atl.earthlin k.net...
鉴于：< TblSurveyResponse
SurveyResponseID
ResponderID
SurveyItemID
ResponseYesNo
可以编写单个SQL来返回所有回复的响应者ID
SurveyItemID 4和否到SurveyItemID 7？
谢谢！
Given:
TblSurveyResponse
SurveyResponseID
ResponderID
SurveyItemID
ResponseYesNo
Can a single SQL be written to return all ResponderIDs who annswered Yes
to SurveyItemID 4 AND No to SurveyItemID 7?
Thanks!
选择ResponderID，SurveyItemID， ResponseYesNo
Select ResponderID,SurveyItemID,ResponseYesNo
from tblSurveyResponse as sr
From tblSurveyResponse as sr
where（sr.SurveyItemID = 4 and sr.ResponseYesNo =''Yes''）
或（sr.SurveyItemID = 7和sr.ResponseYesNo =''No''）
或（sr.SurveyItemID = 9和sr.ResponseYesNo =''是''）
或（sr.SurveyItemID = 11且sr.ResponseYesNo =''No''）
where (sr.SurveyItemID = 4 and sr.ResponseYesNo = ''Yes'')
or (sr.SurveyItemID = 7 and sr.ResponseYesNo = ''No'')
or (sr.SurveyItemID = 9 and sr.ResponseYesNo = ''Yes'')
or (sr.SurveyItemID = 11 and sr.ResponseYesNo = ''No'')
这篇关于可以编写单个SQL吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
