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

Sathwik1 · 8 hours ago

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.

Sathwik1 · 8 hours ago

Chaitanya ILCR · 7 hours ago

Try using the " . " instead of the " _ " like (ucread.user_criteria=uc.sys_id)

did you add any view fields to the view tables?

if yes make sure the fields used in the where clause are included

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

Regards,
Chaitanya

Sathwik1 · 7 hours ago

Now it's fine, but I don't see any data in the table.

Yes, I added views.. screenshot below.

Chaitanya ILCR · 6 hours ago

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