>>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,
Hi Jim,
this way works.
Thanx