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 

[Chaitanya ILCR]

Hi @Sathwik1 ,

I have tried the same and it works for me

create one more database view and do not add any view fields to any view tables this time and check

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[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