I need help with a SQL Server query.
I have a many to many relation between tables Task and Project. The linking table is Task_Project.
I also have a one to many relation between tables Task and Notes.
I want a query that will return:
All the Tasks (TaskName column), with or without Notes (Body Column), and all the Tasks with or without Projects (Project Name) attached to them.
How can I do this?
I have included a relational diagram with this post to help visualize the relation between the tables.