[SQL Server] Where Statement |
| Posted: 26 Aug 2013 01:42 AM PDT I want to do a "where statement" using "OR". When I try to run it, the right info does not come out. Can you see what I am doing wrong.thank youSELECT SV00300.Service_Call_ID ,SV00300.Service_Description,SV00300.DATE1 ,SV00300.LOCATNNM ,SV00300.CUSTNAME ,SV00300.CUSTNMBR ,SV00300.ADRSCODE,SV00300.Type_Call_Short,SV00300.Contract_Number ,DAM_TechEE_Info.FRSTNAME,DAM_TechEE_Info.TechnicianFROM SV00300 FULL OUTER JOIN WS30702 ON SV00300.Service_Call_ID = WS30702.WS_Job_Number INNER JOIN DAM_TechEE_Info ON WS30702.EMPLOYID = DAM_TechEE_Info.EMPLOYIDWHERESV00300.DATE1 Between (@Start_Date) and (@End_Date)and SV00300.CUSTNMBR in (@CUSTNMBR)or SV00300.DATE1 Between (@Start_Date) and (@End_Date)and SV00300.LOCATNNM in (@LOCATNNM)or SV00300.DATE1 Between (@Start_Date) and (@End_Date)and SV00300.Contract_Number in (@Contract_Number) |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server Newbies To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment