Database view error

[dgarad]

 I have created a database view I got an error.

[Dr Atul - LNG]

Hi @dgarad 

Please share the table and where clause conditions. 

[dgarad]

Hi @Dr Atul - LNG 

 below ss of table and where clause conditions

[Dr Atul - LNG]

HI @dgarad 

https://www.servicenow.com/community/developer-forum/database-view-giving-error-syntax-error-or-acce...

The fix was to update "order" column. So the table that is primary and have no dependency then it should be 100 and subsequent can be 200 and so on.

[dgarad]

Hi @Dr Atul - LNG 

I have changed the order also not working.

Thanks