What is wrong with this? ANY(SELECT (Bygning...

(Bjarne Allerup) #1

What is wrong with this?

ANY(SELECT (Bygninger[Bygning navn], [BygningID]=[_THISROW]. [[BygningID]))

I want to select “Bygning navn” from a table Bygninger where BygningID in this row =

BygningID in table Bygninger.

Pleqase Advice.

(Bjarne Allerup) #2

Please just forget, I found the solution. Should be: SELECT (Bygninger[Bygning navn], [BygningID]=[_THISROW].[BygningID]) Translate