This sounds like an enhancement, not a bug per-se. SQL92 seems
to say the below about searched update statements. What
was the error you got from your first query? (I'd guess
a parser error at t1?)
::=
UPDATE
SET
[ WHERE ]
Stephan Szabo
[EMAIL PROTECTED]
On Tue, 29 Aug 2000 [EMAIL PR
andrew brown ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
table aliases with updates
Long Description
It appears that table aliases cannot be used in update queries for the table we are
updating.
Sample Code
This doesn't w