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

[Barry G. Sumpter]

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));


If anyone knows how to do this, could you please post a sample that you know
works?