Re: SYNTAX ERROR
Yes,
SELECT INTO table doesn't exist. There's either INSERT INTO table SELECT or SELECT INTO file. I believe you want the first one.
insert into review(wrk_rev) select min(wrk_count) from tp_workflow where wrk_prepby = CreBy and wrk_projname =ProjName group by wrk_apr limit 1;
Arnold Daniels
developer.javeline.net
Subject
Views
Written By
Posted
3556
July 31, 2007 11:38PM
Re: SYNTAX ERROR
2262
August 14, 2007 06:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.