4 Replies Latest reply: Aug 6, 2012 12:23 PM by melaniehuggins RSS

    script error

      Hello

       

      Being new to QV and SQL and lots of other things(!) - I'm not too sure why this won't load in my script. I get an error message saying

      Incorrect syntax near the keyword 'FROM'.

       

      Can anyone help?

       

       

       

      SQL SELECT search_Incident_IncidentTypes.IncidentID,
           search_Incident_IncidentTypes.IncidentType,
           search_Incident_IncidentTypes.bActive, search_Incident_Custom_Joined.DateSubmitted,
           search_Incident_Custom_Joined.DateRaised, search_Incident_Custom_Joined.Region,
           search_Incident_Custom_Joined.Status, dbo_search_Incident_Custom_Joined.Site,
          
      FROM (V_IncidentDB.dbo.search_Incident_IncidentTypes) INNER JOIN V_IncidentDB.dbo_search_Incident_Custom_Joined ON
      search_Incident_IncidentTypes.IncidentID = search_Incident_Custom_Joined.IncidentID

      WHERE
      ((search_Incident_IncidentTypes.bActive)=1) AND ((search_Incident_Custom_Joined.DateSubmitted) Is Not Null) AND
      ((search_Incident_Custom_Joined.Site)<>'Test Site') AND ((DateRaised) >= '4/1/2012');