This is my company Table

```
CompanyID, CompanyName

```

This is my Contact Table

```
ContactID, ContactName, CompanyID

```

This is my Report Table

```
ReportID, ReportName

```

This is my ReportContact Table, Many to Many Relationship

```
ContactID, ReportID

```

I want to return all ALL my CONTACTID of 1 company, include those who are not assign to any report, I also want to return the reportID that are assign to different contacts

1 contacts can be assign to many reports
1 reports can consist of many contacts

My current SQL CODE only manage to get the 2 contactID in the ReportContactTable

```
SELECT rc.ContactID, rc.ReportID  from contact c INNER JOIN Reportcontact rc on c.ContactID = rc.ContactID Where CompanyID=1

```

how can Return all the contact include those not in the reportcontact table, but get the reportID at the same times?