AnsweredAssumed Answered

ExecuteSQL Where clause question?

Question asked by BruceHerbach on Feb 26, 2016
Latest reply on Feb 26, 2016 by user19752

I have a foreign key ID field that has a list of IDs.  I would like to run an ExecuteSQL query that will return another field in the record when a specific ID is in the foreign key field.  The query below works if the search value is the first/top item in the list.  The search fails if the matching value is not the first item in the list.   Is there a way to get ExecuteSQL to match on any value in the foreign key field?

 

--- Current query,  works when ? is first value in the list.

SELECT a."Area_ID"

FROM "FieldManagement" a

WHERE a."PartDailyGoal_ID" = ?

 

Thanks much

Bruce

Outcomes