Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JJins
Yak Posting Veteran
81 Posts |
 Posted - 2010-10-20 : 16:28:59
|
| Here is the delete statement that is not working for me. It is saying the error is happening around the INNER Join. Any IdeasDelete From RateData INNER JOIN Programs ON RateData.ProgramID = Programs.ProgramIDwhere ratedata.coverageid = 1 programs.state = 'NJ' and programs.policytype = 6then the error is....Msg 156, Level 15, State 1, Line 1Incorrect syntax near the keyword 'INNER'. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
JJins
Yak Posting Veteran
81 Posts |
Posted - 2010-10-20 : 16:46:48
|
| I think you just did the exact same thing I had. maybe this will help.......database = Rating_2 and table = ratedata. and the table I want to inner join with is programs.this is the error I recieved when i ran your code.Msg 4104, Level 16, State 1, Line 1The multi-part identifier "r.ProgramID" could not be bound.Msg 208, Level 16, State 1, Line 1Invalid object name 'r'. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Delele with inner join