Hello all,

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:

CREATE table2.
ASSIGN table2.field1 = table1.field3
table2.field2 = table1.field1
table2.field3 = table1.field9.

END.

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.

Elliot J

On 6/20/2005 3:02 AM, Elliot J wrote:
INSERT INTO DestTable ( field1, field2 )
SELECT SourceTable.field1, SourceTable.field2
FROM SourceTable;