<div>
Is this an homework question?
</div>


<div>
No its not a homework question Sharath_123. &nbsp;Thank you all.
</div>


No its not a homework question Sharath_123.  Thank you all.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I need help with a SQL Server query. <br />
I have a many to many relation between tables Task and Project. &nbsp;The linking table is Task_Project.<br />
I also have a one to many relation between tables Task and Notes.<br />
I want a query that will return:<br />
All the Tasks (TaskName column), with or without Notes (Body Column), and all the Tasks with or without Projects (Project Name) &nbsp;attached to them.<br />
How can I do this?<br />
<br />
I have included a relational diagram with this post to help visualize the relation between the tables. <a href="https://filedb.experts-exchange.com/incoming/2011/04_w18/449111/RelationalDiagram.bmp" target="_blank" title="Relational Diagram (622 KB)"><img alt="Relational Diagram" class="file-block lazyload" style="max-width: 600px;" data-src="https://filedb.experts-exchange.com/incoming/2011/04_w18/449111/RelationalDiagram.bmp" /></a>
</div>
</div>


RelationalDiagram.bmp

Hi Experts,
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. 

I need help with a SQL Server query that pull data from a Many to Many relation and a One to Many relation

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.