如何使用选择查询进行搜索 [英] How to search using Select Query

问题描述

什么是storedproc或select查询，我要搜索状态为3的学者运输字段，但随后显示所有这些状态的字段，我只想针对学者运输查看这些状态:Plz帮助

这是我的选择查询

what is the storedproc or select query for i want to search scholar transport fields that has 3 statuses ,but then it shows all the Field that has these statuses of which i want to view only for Scholar Transport: Plz Help

This is my Select Query

SELECT  CI.CHLD_REF,CI.CHLD_ID,CI.CHLD_NAME, CI.CHLD_SURNAME ,CI.CHLD_SchoolID,
        CI.CHLD_BIRTH_DATE, s.SVC_NAME, cs.CSVC_STATUS, cs.CSVC_UPDATE,
        cs.CSVC_EMPL_DN, E.Name, E.Surname,cs.CSVCID,cs.CSVC_SVC_ID
FROM CHILD_SERVICE1 AS cs 
INNER JOIN CHILD_INFO AS CI ON cs.CSVC_CHLD_ID = CI.CHLD_ID 
INNER JOIN SERVICES AS s ON cs.CSVC_SVC_ID = s.SVC_ID 
INNER JOIN EmpUsers AS E ON cs.CSVC_EMPL_DN = E.UserName
WHERE  cs.CSVC_STATUS = 'Approve' or cs.CSVC_STATUS = 'Decline'
        or cs.CSVC_STATUS = 'Not Approved' 
        and s.SVC_NAME ='SCHOLAR TRANSPORT' 

推荐答案

hi，
只需使用()

hi ,
just use the ()

SELECT  CI.CHLD_REF,CI.CHLD_ID,CI.CHLD_NAME, CI.CHLD_SURNAME ,CI.CHLD_SchoolID ,
        CI.CHLD_BIRTH_DATE, s.SVC_NAME, cs.CSVC_STATUS, cs.CSVC_UPDATE,
        cs.CSVC_EMPL_DN, E.Name,E.Surname,cs.CSVCID,cs.CSVC_SVC_ID
FROM CHILD_SERVICE1 AS cs 
INNER JOIN CHILD_INFO AS CI ON cs.CSVC_CHLD_ID = CI.CHLD_ID 
INNER JOIN SERVICES AS s ON cs.CSVC_SVC_ID = s.SVC_ID
INNER JOIN EmpUsers AS E ON cs.CSVC_EMPL_DN = E.UserName
WHERE (cs.CSVC_STATUS = 'Approve' or cs.CSVC_STATUS = 'Decline' or 
        cs.CSVC_STATUS = 'Not Approved') 
        and s.SVC_NAME ='SCHOLAR TRANSPORT'

希望这对您有帮助:)

hopefully this will help you out :)

这篇关于如何使用选择查询进行搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！