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 |
|
mana
Posting Yak Master
102 Posts |
 Posted - 2015-02-12 : 06:49:43
|
| HelloI have the following code in sql server and then i have the below problem. can you help me please?thank youError message: The multi-part identifier 'Fzg.EUR' could not be boundupdate dbo.Inv_Adjustments_Chartspart1set Fzg. EUR = B.kosten_sumfrom dbo.Inv_Adjustments_Chartspart1 Aleft join (SELECT SUM(Kosten_Gesamt) as kosten_sum,Datum_Produktion_DeklarationFROM dbo.v_Inv_Adjustments_Chartspart1group by Datum_Produktion_Deklaration) B onA.Offline_date=B. Datum_Produktion_Deklaration |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-02-12 : 06:52:05
|
| Which of the two tables has the column EUR? |
 |
|
|
mana
Posting Yak Master
102 Posts |
Posted - 2015-02-12 : 06:53:36
|
| TABLE dbo.Inv_Adjustments_Chartspart1 |
|
|
|
mana
Posting Yak Master
102 Posts |
Posted - 2015-02-12 : 07:05:43
|
| dO YOU KNOW WHERE my problem is? |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-02-12 : 08:42:25
|
Sure! in your update you have:set Fzg. EUR = B.kosten_sum but the name "Fzg" is not found anywhere else in your query. So, when SQL sees that name, it does not know what you are refering to. |
|
|
|
|
|
|
error message