My Assistant
|
|
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 |
|
|
|
MikeLyons QUOTE (David92595 @ Feb 2 2012, 10:48 AM)... Feb 2 2012, 02:33 PM
ScottGem The problem is that you can't reference a fiel... Feb 2 2012, 03:29 PM
niesz If this returns the correct records:
SELECT j.TS,... Feb 2 2012, 03:44 PM
Doug Steele Have to wonder whether that's really what Davi... Feb 2 2012, 04:00 PM
niesz You may be right ... I was just going by his initi... Feb 2 2012, 04:17 PM
Doug Steele Actually, that was the phrase that caught my atten... Feb 2 2012, 04:37 PM
David92595 Thank you everyone for the great comments. They... Feb 2 2012, 04:53 PM
MikeLyons QUOTE (Doug Steele @ Feb 2 2012, 01:00 PM... Feb 2 2012, 05:01 PM
Doug Steele CODEUPDATE Loan_Info_Local INNER JOIN Judicial_Com... Feb 2 2012, 05:06 PM
David92595 I'm getting an error:
"Incorrect syntax n... Feb 2 2012, 05:16 PM
Doug Steele Interesting. That was copied-and-pasted from a wor... Feb 2 2012, 05:23 PM
niesz Try it this way:
UPDATE Loan_Info_Local
SET Judi... Feb 2 2012, 05:26 PM
David92595 Doug thank you for your attempt.
niesz, it worked... Feb 2 2012, 05:30 PM
niesz Glad we could all assist. Feb 2 2012, 05:39 PM![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 20th June 2013 - 01:43 AM |