Hello, can someone help me with the following type of query in firebird, so I want to put several numbers of cpf in the IN of a query and if the cpf exists in the table show the data, but if it does not exist show a column indicating that does not exist in the table.
Exemplo:
Select * from trabalhador where cpf in ('11111111111','22222222222','33333333333','44444444444','55555555555')
Na tabela no existe os três primeiros CPF então o resultado seria
11111111111 Ana
22222222222 Carla
33333333333 Maria
44444444444 CPF NÃO EXISTE
55555555555 CPF NÃO EXISTE