not sure if this insert query is compatible
I'm sure this isn't the best idea but I use Access2000 linked to my postgresl 7.4 database to help me create my queries quickly. Then I move the query and make it work for Dreamweaver MX 2004/PHP. I'm trying to create an append query that will dump multiple records into a table. I'm not sure if this sql is compatible with my setup but here it is:
INSERT INTO tbl95 ( col13, col2, col27, col28, col30, col31, col32, col33, col34 )
SELECT view1.col23, view1.col2, view1.physician, view1.totaltopay, view1.col4, view1.col5, view1.col6, view1.col7, view1.col8
I'm also trying to get it so that col35 would be a sequential number starting from a parameter is set. ie. the user enters 122, then the records that are added would enter into col35 the number 122, then on the next record it would add 123, then next record 124, etc. Is this all possible?