How to write clauses to merge 4 tables in database view

[Balakrishna_ABK]

I want to merge idea demand story and label entry tables for database view. I have create where clauses as shown in screenshot however its not working. Please let me know anything to update ?

[Ct111]

There is some OOB database view already present in the system for three tables like change_request_metric  .

Check that as the reference point to work on your case. 

Also below link shows similar case of four tables check that , it will be good reference point for you.

LINK

I hope this helps

[vivek11]

Hi @Ct111 
Good Morning
I have same requirement. But which you provided link is only 3 tables. If possible Could you please provide me where clauses code for 4 tables?