Hi
I'm wondering if it's possible to convert the following SQL statement into LLBL code.
SELECT * FROM emailaddressingrule ER
LEFT OUTER JOIN dbo.[emailaddressingrule_option] AS vo1
ON (vo1.emailaddressingruleId = ER.emailaddressingruleId
AND vo1.OptionID IN (SELECT OptionID FROM dbo.GetTableResult(@StringValue)))
WHERE vo1.OptionID IS NOT NULL
The GetTableResult function returns a table with a single field (OptionId) from a given string (@StringValue). However I'm not sure if it's possible to use a DBFunction in this manner?
Any help hugely appreciated, thanks!
Gareth