INSERT

[Gerald McNally]

copying data from one table to another using the insert into command but also trying to change 2 of the fields at the same time in visual studio.

INSERT INTO park
(tiller, custref)
SELECT Stock_code, Description, Vat, VatRate, Qty, Price, Total, Discount2, Nominal, tiller, Audit_Trail, AccName, Category, UnitOfSale, custref, DepartNo, Emailed
FROM zread
WHERE (Inv = @find1)
VALUES (@find2, @find3)



tried above but not working.