Get names from another table

[anonymous]

hi guys, i need to get some names from another column called tecnico, i need to show these names in a column, but only if column permissao is equal tecnico.

i tried to use ref, but it get all names

and at valid if i get this error: cannoc compare list

what can i do?

[Steve]

Try:

SELECT(
  whatever-table[Nome],
  ("technico" = [Permissao])
)

[anonymous]

Steve:

auto> SELECT(> whatever-table[Nome],> ("technico" = [Permissao])> )> >

Ty, is what i need