I have a two tables, a company table and a contact table.  There is a foreignID in the company Table to connect it to each other.  My problem is if I do a search using the SQL of this, and a company DOES NOT have a contact (the foreignID is null) it doesn't show up in the results.  All the other records with a contact attached to it will but none of the Companies without a contact associated with it do...  How can I make it so even the null value of a contact gets included with the not null ContactID?

---

Reply from Alex Hedley:

Check your Joins, if you double click on it there should be three options, choose show all records in Company, instead of the where it matches