I have several tables, but of most importance to this problem, is a Search Term Data table and a Keyword Data table. These tables are both connected to a Campaigns table via a many to one relationship on a Campaign ID related connection.
I am trying to determine, for each entry in Search Term Data, if a Search Term already appears as a Keyword in the Keyword Data table. Complicating this challenge is the need for both Search Term Data and Keyword Data tables be filtered in scope to a specific Campaign ID for this query. If the value does already exist returning TRUE or "Yes" is an ideal goal.
I believe for this to work as intended, I need to create a new column so that each row of Search Term Data has its own result. When I searched around, most of the similar questions here did not work or account for this specific use case with both tables needing to be filtered first.