UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Quick Insert Into Problem, Office 2007    
 
   
David92595
post Feb 2 2012, 01:48 PM
Post #1

UtterAccess Addict
Posts: 248



I am trying to insert the column "Judicial_Comments" from a table called "Judicial_Comments" into Column "Judicial_Comments" in a table called "Loan_Info_local". The part that is giving me the error is in the WHERE clause

The error I'm getting:
"Msg 4104, Level 16, State 1, Line 6
The multi-part identifier "dbo.Loan_Info_local.TS" could not be bound."

CODE:
USE ClientDB_MASTER

INSERT INTO Loan_Info_Local (TS, Judicial_Comments)
SELECT TS, Judicial_Comments
FROM Judicial_Comments
Where Judicial_Comments.[TS]=Loan_Info_local.TS
Go to the top of the page
 
+

Posts in this topic


Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 20th June 2013 - 01:43 AM