script error

[#1]

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');

[manisha_uit]

Hi,

Remove the comma from the last field (dbo_search_Incident_Custom_Joined.Site)

Then it should work...

Thanks

Manisha

[#3]

thanks but its still not loading correctly - what else can I try?

[a_mullick]

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

[#5]

thats all working now thanks both of you