[Resolved] How do I get data from 3 tables?

[spstieng]

Hey guys, haven't been doing any SQL for the past 8 months... and need a helping hand here.

I have 3 tables:

Organization
orgID
orgName

ContactDetails
contactID
contactTlf1
contactName
orgID

DialingList
dlID
empID (emplyee ID)
status
orgID

How do I write the SQL code to get the following info:
orgName | contactTlf1 | contactName | status

The only criteria is that;
organization.orgID = contactdetails.orgID
AND dialinglist.empID ="54001"

I haven't quite got the grip for inner, outer and left joins.... 🙁

[bastien]

try

select  Organization.orgName, ContactDetails.contactTlf1, ContactDetails.contactName, DialingList.status 
from Organization inner join ContactDetails on Organization.OrgID = ContactDetails.orgID
inner join DialingList on Organization.OrgID = DialingList.orgID
WHERE
dialinglist.empID =54001

[spstieng]

It worked!

Now all i gotta do is figure out how these inner and outer joins work....

Thanks again!