[RBASE-L] - Re: I'm Stumped

[Bill Downall]

Richard,

I think this is the correct syntax for what you want:


 UPDATE Photolog SET Photographer = p2.PhotogName +
  FROM Photolog p1, Photog p2 +
 WHERE Photographer IS NULL +
    AND (p1.PhotogInitials = p2.PhotogInitials)

 Bill