Re: INSERT INTO TABLE

[Kanwal Khipple]

If for example we have:

Table A (col1, col2, col3) Table B (col1, col2)

Then what you can do is make a query that does what you need in two steps.

FIRST insert into Table A:

INSERT INTO A(col1, col2, col3)
VALUES ('Nature','Buf','')

UPDATE A
SET col3 = 'Buffalo'
WHERE col2 = 'Buf'


How does that work?