Query

[N! Xau]

Hi,

I have TableA
colA1 integer
colA2 integer
colA3 date

and TableB
colB1 integer
colB2 string

I want to select colA1 from 30-last-inserted rows in TableA, and copy
to colB1, while colB2 is a constant string.

I was doing

select colA1 from TableA order by colA3 desc limit 30


but what else?

thanks