I'm trying to update 2 tables in one database. My first query is going through alright. The second one has some bugs.
My code is:
insert into panel_scene_map (scene_id, panel_id)
SELECT MAX(panel_id) AS new_id FROM panel
This is my error message:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
I have double checked the values I'm passing and they are correct. I think it has something to do with the SELECT MAX function. Thanks for the advice!!!