>Hi all,
>I want to extract some names from a table 'x' with a 'where' clause, but only if the names are present in another table 'y'. For example: select name, surname from x where dimessa=0 .and.... (when the name and surname is present in the y table) into cursor mycursor.
>Any idea about the correct statement sql?
One way to do it:
SELECT ... FROM x
WHERE ... AND name+surname IN (SELECT name+surname FROM y)
INTO ...
You might need to adjust the name+surname expression to make sure you get an exact match.
Chris