Simple update query

[countdrak]

UPDATE Training inner join test
on Training.uid = test.uid 
AND Training.EventID = test.EventID
SET Training.StartDate = test.StartDate

Whats wrong with this simple update query!
Incorrect syntax near the keyword 'inner', thats the error I keep getting. *Frustrated* Am I not seeing something? Thanks. Using MS SQL Server 2000

 

[pkailas]

have you tried

UPDATE Training set training.startdate = test.startdate 
Inner Join Test on training.uid = test.eventid

Not sure, but perhaps you have to have the set part first

 

[countdrak]

Nah thats not the problem I keep getting the same error.! Thanks though.

 

[Golom]

You're using SQL Server and this is the MS/Access SQL forum. From an Access perspective the statement looks OK but there may be a reserved words issue with SQL Server. Try something like

UPDATE [Training] inner join [test]
on [Training].uid = [test].uid 
AND [Training].EventID = [test].EventID
SET [Training].StartDate = [test].StartDate

You might try posting in Forum183.

 

[PHV]

Another way:
UPDATE Training
SET StartDate = (SELECT StartDate FROM test
WHERE test.uid = Training.uid AND test.EventID = Training.EventID)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244