I was trying to combine three tables and planning to build a database view

[Sathwik1]

I was trying to combine three tables and planning to build a database view, please check below and confirm what I did wrong?

When I click on trynow, getting below error.

@Ankur Bawiskar 

[Neeraj_27]

Hey, I can see there is space in your 2nd table where clause right after the prefix underscore. Also, the error specifies ucread which points to second table.

I have tried the same what you are trying to build, and it worked fine

[Sathwik1]

@Neeraj_27 No, there is no space.. I tried.

[Sathwik1]

@Ankur Bawiskar can you please check..

My requirement is If I check a knowledge base... I need list of details which has can contibure access and which has canread access