What is the SQL Syntax for updateing fields returned from a Binary Link ?

[Ruslan Zasukhin]

On 14/9/07 1:40 AM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

Hi Barry,
 
> I'm trying something like this but it's not happening.
> 
> UPDATE MenuItems
> SET MenuItems.Caption = "xxx"
> FROM Menus Left Outer JOIN MenuItems ON link_menus_1_M_menuitemsWHERE
> (((Menus.RecID)=2) AND ((MenuItems.Itemno)=100));

There is no such syntax

    UPDATE ... FROM ... WHERE

Exists 
    UPDATE ... WHERE.

I think more correct is something as

UPDATE MenuItems
SET MenuItems.Caption = "xxx"
WHERE
    RecID IN 
        ( SELECT MenuItems.RecID
          FROM Menus LEFT OUTER JOIN MenuItems
                     ON link_menus_1_M_menuitems
          WHERE Menus.RecID = 2 AND
                MenuItems.Itemno = 100
        );

Note, not tested.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]