How do I do this ???

[CoffeeCup]

I?m hoping someone can help with a database query.
I have 2 tables ? 1 has a list of approximately 40 departments. The second
table has a list of branches. (Stores)
Each store is linked to a department but some of the departments don?t have
any linked stores.
I?m trying to write a query that only returns a list of the departments that
have linked stores. The other departments should not be displayed.
Below is my current attempt. However this query still returns the whole
department list. I have tried a standard join but this returns a list that
duplicates the results.

SELECT tbl_departments.*
FROM tbl_departments
WHERE NOT EXISTS (
SELECT tbl_tenant_branch.branchID,
tbl_tenant_branch.departmentID,
tbl_departments.*,
tbl_tenant_branch.centreID
FROM tbl_tenant_branch, tbl_departments
WHERE tbl_tenant_branch.centreID = #SESSION.centre#
AND tbl_departments.departmentID = tbl_tenant_branch.departmentID)

Your help will be greatly appreciated.
Thank you in advance.

[paross1]

SELECT *
FROM tbl_departments td
WHERE EXISTS (SELECT 1
FROM tbl_tenant_branch tb
WHERE centreID = #SESSION.centre#
AND td.departmentID = tb.departmentID)

--or--

SELECT *
FROM tbl_departments td
INNER JOIN tbl_tenant_branch tb ON td.departmentID = tb.departmentID
WHERE centreID = #SESSION.centre#

Phil

[CoffeeCup]

Thank you this works