-5
update [Netlication].[dbo].[SISStockTransaction]
set [Netlication].[dbo].[SISStockTransaction].[atCreateDate]=[test4].[dbo].[SISStockTransaction].[atCreateDate]
from [Netlication].[dbo].[SISStockTransaction],[test4].[dbo].[SISStockTransaction]
where [Netlication].[dbo].[SISStockTransaction].[z1SISStockTransactionId]=[test4].[dbo].[SISStockTransaction].[z1SISStockTransactionId]

whats the wrong in this statement?

PM 77-1
  • 12,933
  • 21
  • 68
  • 111
mohammad hamdan
  • 1
  • Welcome to Stack Overflow , please take a moment to read [how to ask a good question](https://stackoverflow.com/help/how-to-ask) – Neji Soltani Jan 08 '18 at 16:56
  • 2
    [Bad habits to kick : using old-style JOINs](https://sqlblog.org/2009/10/08/bad-habits-to-kick-using-old-style-joins) - that old-style *comma-separated list of tables* style was replaced with the *proper* ANSI `JOIN` syntax in the ANSI-**92** SQL Standard (**25 years** ago) and its use is discouraged – marc_s Jan 08 '18 at 16:58
  • There are numerous things wrong with that query. – Sean Lange Jan 08 '18 at 17:19

1 Answers1

0

Try below .you are missing join 

UPDATE [Netlication].[dbo].[SISStockTransaction]
SET [Netlication].[dbo].[SISStockTransaction].[atCreateDate] = [test4].[dbo].[SISStockTransaction].[atCreateDate]
FROM [Netlication].[dbo].[SISStockTransaction] INNER Join
     [test4].[dbo].[SISStockTransaction] ON [Netlication].[dbo].[SISStockTransaction].[z1SISStockTransactionId] = [test4].[dbo].[SISStockTransaction].[z1SISStockTransactionId]
WHERE [Netlication].[dbo].[SISStockTransaction].[z1SISStockTransactionId] = [test4].[dbo].[SISStockTransaction].[z1SISStockTransactionId];
Anwar Ul-haq
  • 1,851
  • 1
  • 16
  • 28
  • The objects "test4.dbo.SISStockTransaction" and "Netlication.dbo.SISStockTransaction" in the FROM clause have the same exposed names. Use correlation names to distinguish them whats mean this error – mohammad hamdan Jan 08 '18 at 17:17