>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?
>Thanx in advance.

One way (untested).

SELECT Name, Surname ;
  FROM Y JOIN X ;
    ON Y.Name + Y.Surname = X.Name + X.Surname
 WHERE X.Dimessa = 0

Regards,