How can I join 3 tables in a Database view

[Yanal]

Hello community ! who can help and tell me how to join 3 tables in a database view, 

Check the screenshot you will see that my where clause is missing something no idea what it can be

any help would be highly appreciated !! 

thanks 

[Alberto Consonn]

Hi,

There are many out of the box database views that uses 3 tables.

You can refer any one of those, for example the following one:

If I have answered your question, please mark my response as correct and/or helpful.

Thank you very much

Cheers
Alberto

[ggg]

[Yanal]

Can we also join the catalog task table with them ? 
can the task table be a parent for 2 under it ?

[Yanal · Accepted solution]

It cant be done I had to create a table and fill it with the info i need

and thats because there was no relation between the 3 tables I wanted