update+The multi-part identifier

Version imprimable

Bonjour

ma requête est la suivante
Code:

1 2 3 4 5 6 7 8 9 10 11 12 update ref_customer_delta set ff.holding_key = cdt.holding_key, ff.holding_name = cdt.holding_name, ff.CountryUnivarName = cdt.CountryUnivarName, ff.Load_Date = GetDate() where ff.customer_key = (select ff.customer_key from ref_customer_delta ff join ref_customer_delta_temp cdt on ff.ref_customer_delta_id = cdt.ref_customer_delta_id)
et j'obtiens comme message d'erreur :
The multi-part identifier "ff.customer_key" could not be bound.

et pourtant je pense que la requête est sémantiquement correcte!!!!!!!

quelqu'un pourrait m'aider

Merci pour vos réponses

Salut,

Un truc du genre ca passe ?

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
UPDATE ref_customer_delta  
SET 
holding_key =  cdt.holding_key,
holding_name = cdt.holding_name,
CountryUnivarName = cdt.CountryUnivarName, 
Load_Date = GetDate()
------------------------------------------------
from
ref_customer_delta ff
JOIN ref_customer_delta_temp cdt ON 
ff.ref_customer_delta_id = cdt.ref_customer_delta_id
--------------------------------------------------
WHERE
customer_key = 
(SELECT ff.customer_key FROM ref_customer_delta ff
JOIN ref_customer_delta_temp cdt ON 
ff.ref_customer_delta_id = cdt.ref_customer_delta_id)

02/06/2008, 10h31
jawadi95

oui ca marche mais sans le where puiske je fé la jointure après le FROM

Merci