J
Jamie Risk
I have a query constructed by using the wizard:
SELECT
[Politicians].District_ID,
[Politicians].Pol_ID,
[Politicians].Name,
[Professionals].Prof_ID,
[Professionals].Name
FROM
( Districts
INNER JOIN
[Politicians] ON Districts.District_ID = [Politicians].District_ID
)
INNER JOIN
[Profesionals] ON Districts.District_ID = [Professionals].District_ID;
Profesionals to Politicians is a many to one relationship (via the
District_ID).
I'd like to modify the query to essentially get a list of Districts
(Districts.Distric_ID) where there is a politician and at least one
professional.
SELECT
[Politicians].District_ID,
[Politicians].Pol_ID,
[Politicians].Name,
[Professionals].Prof_ID,
[Professionals].Name
FROM
( Districts
INNER JOIN
[Politicians] ON Districts.District_ID = [Politicians].District_ID
)
INNER JOIN
[Profesionals] ON Districts.District_ID = [Professionals].District_ID;
Profesionals to Politicians is a many to one relationship (via the
District_ID).
I'd like to modify the query to essentially get a list of Districts
(Districts.Distric_ID) where there is a politician and at least one
professional.