Where Clause to join 4 tables using database views

[Poorva Bhawsar]

Hi Community,

I have to join 4 tables using database views. All tables have one common field that is user id which is a reference field. How can i join this. Need help with the where clause.

Thanks

[Ankur Bawiskar]

@Poorva Bhawsar 

so all 4 tables have same field with same type?

Are you sure you have data in those tables based on this common field.

share the database view where clause screenshots

[Poorva Bhawsar]

Yes data is there in this common field. What i did is i have created user id field in all the 4 tables and loaded data based on that. All 4 tables extending task table.

[Poorva Bhawsar]

this is what i tried, user name is nothing but user id field. On the table i want to have user id from the ep table. But its showing me completely empty data after joining.

[Poorva Bhawsar · Accepted solution]

Able to join it replaced sys_id with user_name in all the where clauses.

Thanks

[Ankur Bawiskar]

@Poorva Bhawsar 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct as well so that it benefits future readers.