Update query with sql server 2005

msomar · May 2nd, 2010, 02:55 PM

I have select query like this :

Code:

SELECT AdCampaign.CampaignName, AdCampaign.AdType AS [Campaign Type], AdCampaign.Date AS [Start Date], AdCampaign.Clicks, AdCampaign.Impr, AdCampaign.DailyBudget AS [Daily budget] , AdCampaign.Status FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)

I need like the previous query for update.
How I can do it with Join.

melvik · May 2nd, 2010, 11:58 PM

if u want to update account Table u could simple use code below ;)
UPDATE Account SET .......................
FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)

HTH