quote:

---

John writes "I am having trouble with the insert into statement in one of my queries everytime I run the query I get back this error Server: Msg 207, Level 16, State 1, Line 1
Invalid column name 'cancelled_partsField9'.

Here is a sample of the syntax

insert into drf1 (Docuno, WON, Part_No, Part#, REQ, REC, DI, DIC, Closed, Status, Task, WC, [cancelled_partsField9], [drsf_finalfield9], BSL, ADDR, Stic, FC, SSID, RDD)
SELECT Drf.Docuno, Drf.WON, Drf.Part_No, Drf.Part#, Drf.REQ, Drf.REC, Drf.DI, Drf.DIC, Drf.CLOSED,'RC', Drf.TASK, Drf.WC, cancelled_parts.[field9], drsf_final.[field9], Drf.BSL, Drf.ADDR, Drf.STIC, Drf.FC, Drf.SSID, Drf.RDD
FROM ((Drf LEFT JOIN cancelled_parts ON Drf.Docuno = cancelled_parts.Field1) LEFT JOIN received_parts ON Drf.Docuno = received_parts.Field1) LEFT JOIN drsf_final ON Drf.Docuno = drsf_final.Field1
WHERE (((Drf.DIC)<>'D6Z'))
ORDER BY Drf.Docuno;

I have tried simply running the Select statement and leaving out the Insert in the Query analyzer and that works but the Insert does not???

I am using SQL Server 2000 on Windows 2000"

---