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 :)