Trans 1 row to another table?

[4rxsid]

Hi all,

How could I transfer 1 returned row from table A, into table B without getting each column's data in that row (from A) and then doing an insert statement into table B.

Is there a function or sql language to do this?

Thanks

[Lars_Berg]

What d you mean by

without getting each column's data in that row

?

You can copy data from one table to another by, e.g.

insert into t select * from q where a like 'Q%'

Some more info needed.