Need help on query syntax 1

[Cenedra]

I'm updating a field across two databases. I know I"m close, but can you please tell me where my syntax is wrong here?


update Q_UCDavis_1009.dbo.Clients
set Q_UCDavis_1009.dbo.Clients.Race = Q_UCDavis_RACES.dbo.Clients.Race
where Q_UCDavis_1009.dbo.Clients.SSN = Q_UCDavis_RACES.dbo.Clients.SSN

Thanks for your help
Cen

 

[donutman]

UPDATE Q1
   Set Race = Q2.Race 
   From Q_UCDavis_1009.dbo.Clients Q1 inner join 
        Q_UCDavis_RACES.dbo.Clients Q2
   On (Q1.SSN=Q2.SSN)

-Karl



[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]