UPDATE VOD_Programs
SET VOD_Programs.ProgramName=VOD_Virtual_Programs.ProgramName
INNER JOIN VOD_Virtual_Programs ON VOD_Programs.CreateDate=VOD_Virtual_Programs.CreateDate
SET VOD_Programs.ProgramName=VOD_Virtual_Programs.ProgramName
INNER JOIN VOD_Virtual_Programs ON VOD_Programs.CreateDate=VOD_Virtual_Programs.CreateDate
from VOD_Virtual_Programs where VOD_Programs.CreateDate=VOD_Virtual_Programs.CreateDate
from
VOD_Programs a INNER JOIN VOD_Virtual_Programs b ON a.CreateDate=b.CreateDate
UPDATE a SET ProgramName=b.ProgramName
from VOD_Programs a,VOD_Virtual_Programs b where a.CreateDate=b.CreateDate
FROM VOD_Programs
INNER JOIN VOD_Virtual_Programs ON VOD_Programs.CreateDate=VOD_Virtual_Programs.CreateDate
SET VOD_Programs.ProgramName=VOD_Virtual_Programs.ProgramName
FROM VOD_Programs INNER JOIN VOD_Virtual_Programs ON VOD_Programs.CreateDate=VOD_Virtual_Programs.CreateDate
SET VOD_Programs.ProgramName=VOD_Virtual_Programs.ProgramName
from VOD_Programs
INNER JOIN VOD_Virtual_Programs ON VOD_Programs.CreateDate=VOD_Virtual_Programs.CreateDate