Select Component with Join Table

Queries and Resources
1

Hi there my table query is as follows:

SELECT
Projects.ProjectID,
Projects.ProjectName,
Projects.County,
Projects.ProjectType,
Projects.ProjectSubType,
DesignCriteria.GIAIncludingBasement
FROM Projects
FULL OUTER JOIN DesignCriteria
ON Projects.ProjectType=DesignCriteria.GIAIncludingBasement
ORDER BY Projects.ProjectID;

and I can't for the life of me get my select components to work using this table. Any advice greatly appreciated.

2

hey @thomasatkinson -Welcome to the community! Can you send a picture of your select component set up?

Thanks