[RESOLVED] select... insert

dakey

Hello, i am trying to take certain fields from one table and insert them into another table using one query. I have tried using the following sql:

INSERT INTO invoices( ' ', company, firstname, lastname, email, address1, address2, town, city, county, country, postcode )
SELECT company, firstname, lastname, email, address1, address2, town, city, county, country, postcode
FROM `clients`
WHERE id =2

however i get the following error message:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' ',company,firstname,lastname,email,address1,address2,town,city,county,country,' at line 1

by the way i am using MySql version 5.0.67-community

any help greatly appreciated.

bradgrafelman

What is the ' ' supposed to accomplish? In that part of the query, you're supposed to be listing the column names that you are INSERT'ing data into.

Weedpacket

I think dakey's trying to write

INSERT INTO invoices SELECT ' ', company, firstname, lastname, email, address1, address2, town, city, county, country, postcode
FROM `clients`
WHERE id =2

dakey

doh, im such an idiot. got it working thanks.

although i now have another sql query. I have this query here:

SELECT * FROM `invoices` ORDER BY date

however i want to add to this these three queries to it, how do i do that?

SELECT SUM(sub) AS totalSub FROM lines WHERE invoice_id = invoices.id


SELECT SUM(vat) AS totalVat FROM lines WHERE invoice_id = invoices.id


SELECT SUM(total) AS totalTotal FROM lines WHERE invoice_id = invoices.id

Weedpacket

I think this should be a new thread.