Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Update info from one table to another.

Author  Topic 

jamie
Aged Yak Warrior

542 Posts

Posted - 2003-10-29 : 04:48:00
Hello all,

why is this update statement, displaying an error : Incorrect Syntax near ','
?

UPDATE Establishments, v_Email SET Establishments.Email1 = v_Email.[Email address] WHERE Establishments.id = v_Email.id

thanks for any info !
Jamie

jamie
Aged Yak Warrior

542 Posts

Posted - 2003-10-29 : 04:58:53
nevermind this one, I'm being an idiot !
(Monday morning !)
Go to Top of Page
   

- Advertisement -