How can we help you today? How can we help you today?

Table Aliases not always handled properly

Sample code
UPDATE T 
	SET dbo.Table_1.
 FROM dbo.atbl_Accounting_OrdersDeliveries  AS T 
	INNER JOIN dbo.atbl_Accounting_OrdersItems AS I 
		ON T.Domain = I.Domain AND T.Template = I.Template	

When trying to enter SET T. to start setting fields, it autoselects the first table starting with a T. The same thing when entering UPDATE T; The alias does not turn up in the list, but since I don't have SPACE selecting from the list this one goes OK.
dottNett
0

Comments

1 comment

  • simon.jackson
    Thanks for pointing this out. I'm afraid we don't support fully the aliased syntax for updates. I've raised the issue in our bug tracking system and we will look at fixing it in a future release.

    Thanks again


    Simon
    simon.jackson
    0

Add comment

Please sign in to leave a comment.