aleks

Hi,

I need to copy over some values from table # 1 to table # 2 and I need a
little help doing so, here is the info, maybe someone can help me out
creating this query.

Table # 1

field1 : attachment_id (int)
field2: user_id (int)

Table # 2

field1: attachment_id (int)
field2: Object_id (int)

I need to copy over for all records in table one field # 1 to field # 1 in
table # 2 and field # 2 to field # 2 in table 2.

I think this is simple, just never done it before.

Any help appreciated.

A

amit

Try this:

Insert into Table2 (attachment_id, object_id)
Select attachment_id, user_id as object_id
from Table1

aleks

Excelent, thanks !

Aleks