Multi-table query join

Bud, I also attempted to do the query with a join as follows:

SELECT distinct proj_concentration.service, proj_resources.r_filename, deliverables.d_filename
FROM proj_resources, proj_concentration, deliverables, project, proj_services
WHERE project.org_ID='AALC'
AND project.org_ID=deliverables.org_ID
AND project.org_ID=proj_concentration.org_ID
AND proj_concentration.service=proj_services.service
AND proj_services.service=proj_resources.service;

it works but it gives me several possible combinations (40 rows) of service, resources, and deliverables when there should not be this many. Better, but still redundant. Any other suggestions? Left join/right join perhaps? Thanks for the help.