Database view error

[dgarad]

 I have created a database view I got an error.

[Dr Atul - LNG]

Hi @dgarad it may be issue with Where clause. @AshishKM  any help here.

[AshishKM]

Hi @dgarad , 

Can you switch the where condition and test it.

-Thanks,

AshishKM

[dgarad]

Hi @AshishKM 

I have tried this also.

[AshishKM]

if you remove the where clause, what's the output.

[dgarad]

Hi @AshishKM 

The same error occurs. When I removed both tables, as per the below screenshot, the error disappeared.