Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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');
Hi,
Remove the comma from the last field (dbo_search_Incident_Custom_Joined.Site)
Then it should work...
Thanks
Manisha
thanks but its still not loading correctly - what else can I try?
Hi,
Double check the way you have qualified the field names. It looks like a typo could be causing the problem?
search_Incident_Custom_Joined.Status, dbo_search_Incident_Custom_Joined.Site,
FROM (V_IncidentDB.dbo.search_Incident_IncidentTypes) INNER JOIN
Thanks,
Azam
thats all working now thanks both of you