Home

Nested Saved User Defined Functions Error

Eugene Daniel Niemand
Occasional Visitor

I created a saved function to get a dataset lets call it fn_A(). I then created another function that takes some data and join it to fn_A() and saved this as fn_B(). In the designers they work a treat, however when I create a new query and try use fn_B() it errors with:

'join' operator: Failed to resolve table or column expression named 'fn_A'

 Any ideas would be appreciated.