Need help with JOIN

[spstieng]

Hey guys. I'm not familiar using joins. So I'm hoping you guys could help me.

This is the select statement:

SELECT
  organization.*, 
  contactdetails.*, 
  ringeliste.ringelisteStatus, ringeliste.notat
FROM organization 
INNER JOIN contactdetails ON organization.OrgID = contactdetails.orgID 
INNER JOIN ringeliste ON organization.OrgID = ringeliste.orgID
WHERE ringeliste.empID ='54001'
AND ringeliste.status <> "Ringt";

The output is:

| Company 1| Telephone num | Contact person | Status|
| Company 2| Telephone num | Contact person | Status|
| Company 3| Telephone num | Contact person | Status|

This is correct... as long as each company only has 1 contactperson.
If I add e.g. 2 more contactpersons for a company (contactdetails table gets 2 more entries) - the output is increases by two!!!!
Even if a company had 10 contacts, the output should only be 3!

Why is this happening??

[eoghain]

When you do an inner join you are asking for every matching row from every table.

So if you have 1 company with 3 contacts you will get 3 rows, when joining your Contacts and Companies tables.

[spstieng]

Is there a way I can avoid this?

I only want the one row with the company. Not three if the company has three contacts.

[eoghain]

The only way to avoid this is to adjust your where clause to make sure you only get 1 contact match.