M
marian.edu
Guest
Ha, have to admit never saw any update statement using aliases… even so I still think this is not valid SQL even it might well be supported by a number of vendors out there, the table alias can only be used in the FROM clause. update "alias" set “alias”.acc_desc=? from “account” [as] “alias” where "alias".gl_account = ? I do believe this is somehow MS SQL specific, the SQL92 BNF I have doesn’t allow using ‘from’ clause: UPDATE SET [ WHERE ] Anyway, there is really no reason for them to use an alias in this case and it looks like they are not doing that for every table so… if it hurts doing so, stop doing it 
Continue reading...
Continue reading...