Use of SQL SET command to create file alias

  • Thread starter Thread starter KarenSue
  • Start date Start date
K

KarenSue

I have inherited an application from another programmer. Could someone
explain why alias 'a' and 'b', below, are merely listed after the UPDATE
command but for alias 'c', the SET command is used? I thought the SET
command is used to 'set' one field equal to the value in another, as used in
the second instance of SET, below.

UPDATE Combined_Status AS a, Keywords AS b SET Group_Sort AS c
SET a.sort_flag = c.minimum_sort

Thank you from a rusty query writer trying to brush up her skills.
 
KarenSue said:
I have inherited an application from another programmer. Could
someone explain why alias 'a' and 'b', below, are merely listed after
the UPDATE command but for alias 'c', the SET command is used? I
thought the SET command is used to 'set' one field equal to the value
in another, as used in the second instance of SET, below.

UPDATE Combined_Status AS a, Keywords AS b SET Group_Sort AS c
SET a.sort_flag = c.minimum_sort

Thank you from a rusty query writer trying to brush up her skills.
Click to expand...
That does not appear to be a legal statement. The SET keyword should
only be used once in an UPDATE statement. It has nothing to do with
tables or assigning aliases. It is used to signal the start of the
clause where values are assigned to columns.
 
Back
Top