"missing VALUES keyword"
I read lots of articles, ..but can't resolve this simple statements..:
Insert into F40UI74_Archive where (
select * from F40UI74 a, F4211 b
where a.awdoco=b.sddoco and a.awdcto=b.sddcto
and a.AWKCOO=b.sdkcoo and a.awlnid=b.sdlnid
and b.sdcndj=0
and b.sdupmj between 113256 and 113263
)
log result:
Error starting at line 1 in command:
Insert into F40UI74_Archive where (select * from F40UI74 a, F4211 b)
where (a.awdoco=b.sddoco and a.awdcto=b.sddcto and a.AWKCOO=b.sdkcoo and a.awlnid=b.sdlnid and b.sdcndj=0 and b.sdupmj between 113256 and 113263)