The Little Guy Posted January 4, 2012 Share Posted January 4, 2012 I am running this query on Access 2007: insert into tblArTransDetailTemp (transId) values ((select max(transId)+1 from tblArTransDetail)); And I am getting this error: Query input must contain at least one table or query. I have no Idea what is wrong, the tables, exist, the columns exist. The sub select works by its self, the insert works by its self, why don't they work as one? What could be wrong? Link to comment https://forums.phpfreaks.com/topic/254371-access-2007/ Share on other sites More sharing options...
Adam Posted February 13, 2012 Share Posted February 13, 2012 Very late response, but only just spotted this thread. You fix the issue? I suspect Access' rubbish error handling was a red herring, and that the problem is you aren't able to use a sub-query on the same table when inserting into it. Link to comment https://forums.phpfreaks.com/topic/254371-access-2007/#findComment-1317638 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.