Notice the Col1 values 13, 14 and 15. What I want is to get the max of Col1 in existing table-A (which is 12) and then add 1 to that (that becomes 13). Then repeat the same for next row but this time the max should be 13. And so on.
Following is the query I used:
INSERT INTO Table_A ( Col1, Col2)
SELECT (select max(C1.Col1) from Table-A C1) + 1, Table_B.Col2
This gives me the following results:
Col1 (Integer), Col2 (text)
Please help me achieve the result I want.
Thanks atom in advance.
PS: NB - I do not know VB etc so would prefer to have SQL level help. Thanks