Moatez Bouhdid Moatez Bouhdid - 1 year ago 63
SQL Question

Join three tables into a join table

I have three entities with Many-To-Many relationship between all of them

. I want to join the three tables into one table
that contains only the IDs of the three tables.

But I don't understand how can I join them with
plus how can I manage the cascade Types.

Any help would be appreciated.Thanks
P.S: if there's any other idea it's welcome.

Answer Source

You can select from dinamic temp table

select * from (
    inner join Project on user.join_key = Project.join_key
    inner join  Task  on task.join_key = = Project.join_key
) collaborator
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download