Progress code into SQL - 06-20-2005 , 03:02 AM
I am attempting to do something in SQL, which I would imagine is quite
straight forward, however my SQL knowledge is abysmal.
I am basically just trying to create a record in table2, for every
record in table1, using values from table1.
In beloved Progress, I would have gone about it like this:
FOR EACH table1 NO-LOCK:
ASSIGN table2.field1 = table1.field3
table2.field2 = table1.field1
table2.field3 = table1.field9.
I haven't used Progress for years now, but I think that would pretty
much be it.
Would anyone be kind enough to translate the above to basic SQL please?
Thank you very much.
Re: Progress code into SQL - 06-20-2005 , 09:56 AM
On 6/20/2005 3:02 AM, Elliot J wrote:
SELECT SourceTable.field1, SourceTable.field2