Hi all. My first post so bare with me if I have chosen the wrong place to ask. I created a table in JavaDB like this: Code: CREATE TABLE DIRECTION( DIRECTION_ID INT PRIMARY KEY NOT NULL GENERATED DEFAULT AS IDENTITY, SOURCE_AREA_ID INT NOT NULL ); (it's a bit shortened but will prove my point. Now I would like to throw in some data by using INSERT with a SELECT query like this: Code: INSERT INTO DIRECTION SELECT AREA_ID FROM FOOBAR_AREA; The error thrown is (as expected): The number of values assigned is not the same as the number of specified or implied columns. Then I try: Code: INSERT INTO DIRECTION SELECT {auto|default|xxx?},AREA_ID FROM FOOBAR_AREA; and nothing helps. How DOES one do an INSERT using select query into a table with an auto-generated identity column ? Thanks !