<update><table>a</table><set><set_item><table_column><table>a</table><column>orderby</column></table_column><source_column><source>b</source><column>orderby</column></source_column></set_item></set><from><aliased_table><table>bgfl</table><table_alias>a</table_alias></aliased_table><aliased_table><query><select_list><column>orderby</column><column>bgflbh</column></select_list><from><table>bgfl</table></from><where><expression><column>orderby</column><operator>&lt;&gt;</operator><value>0</value></expression></where></query><table_alias>b</table_alias></aliased_table></from><where><expression><function><function_name>substring</function_name><function_parameter><source_column><source>a</source><column>bgflbh</column></source_column><value>1</value><value>6</value></function_parameter></function><operator>=</operator><source_column><source>b</source><column>bgflbh</column></source_column></expression></where></update>