update pageobj ; >set left = c_pageobj.left ; >from c_pageobj ; >where c_pageobj.k_pageobj = pageobj.k_pageobj ; >and c_pageobj.k_page = pageobj.k_pageIt is of course a reserved word and used as a function name and as a keyword (and as a property name as well). However VFP tables themselves use many keywords, meaning it is not carved in stone that you cannot use a keyword. You can use them, just it is not suggested you to do so.
update pageobj ; set pageobj.left = c_pageobj.left ; from c_pageobj ; where c_pageobj.k_pageobj = pageobj.k_pageobj ; and c_pageobj.k_page = pageobj.k_pageIf SQL is used to mean SQL server then:
update pageobj ; set pageobj.[left] = c_pageobj.[left] ; from c_pageobj ; where c_pageobj.k_pageobj = pageobj.k_pageobj ; and c_pageobj.k_page = pageobj.k_pageCetin