I need to develop a grid on a table but only on records whose primary key exists in another table.
The SQL command would be something like:
[INDENT]SELECT
[INDENT]parid,
parnombre,
partuser[/INDENT]
FROM
[INDENT] “public”.parametros
[/INDENT]
WHERE EXIST (
[INDENT] SELECT
[INDENT] pcaid
[/INDENT] FROM
[INDENT] “public”.parametros_categories
[/INDENT] WHERE pcaid = 1 AND “public”.parametros_categorias.parid = “public”.parametros.parid)
[/INDENT]ORDER BY parid
[/INDENT]
But this command fails if I indicate in the SQL option of the application
Thanks