Hi all,

I HAVE
*-- MEDICNOM.DBF WITH TEMESTA 2.5
*-- TRAITER.DBF WITH JEAN - PIERRE - PAUL ( They Have Temesta 2.5 )

medicnom.gresident is a memo field

I want for Medicnom temesta 2.5 a value for gresident =
"JEAN
PIERRE
PAUL"

   UPDATE Me ;
    SET gresident= '',;
    gresident =;
    Tr.cnomteleph + CR ;
    FROM Medicnom Me;
    JOIN Traiter Tr ON Tr.imedicid = Me.iid ;
   WHERE EXISTS (;
    SELECT Tcor.imedicid FROM Traiter Tcor )

Give only a record ( g PAUL and NOT PIERRE OR PAUL )

Ps PIERRE PAUL AND JEAN HAVE Temesta 2.5

Thank very much for help


bernhart