>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