I've got two tables.

Table_A (nid, vid, type, title, uid)

Table_B (id, questiontext)

I need to insert records from Table_B into Table_A. I tried this:

INSERT INTO Table_A (nid, vid, type, title, uid)
VALUES ('', '', multichoice', (SELECT questiontext from Table_B), '1')

but it's throwing an error.

What should be the correct statement?

UPD: I should add that nid is autoincrement and the value of vid should be same as nid.

Edit
Report