How to create view on multiple tables

[patibrahm]

Can anyone tell me how to create view with multiple tables. We have to query following four table.

Features(rm_feature)

Feature Requested Items Table(u_m2m_features_requested_items)

Requested Items(sc_req_item) and

Catalog Task (sc_task)

Requested Items Table is a related table to Feature table

Catalog Task table is related table to Requested Items Table I have created below view but it is not working.

Requested Items Table is a related table to Feature table

Catalog Task table is related table to Requested Items Table I have created below view but it is not working.

[patibrahm]

Sorry didn't attach screen shot in the previous reply.

[Andras Kisgyorg · Accepted solution]

Hello,

Please find below the screenshot of left join field which can be added and set to true:

[patibrahm]

Thank you very much Andras.   Thank you for your help.

It is working fine

[ServiceNow SA]

Hey, Did you set left join to true for all tables?