problem updating table based on results from another table 1

[elpico]

I'm struggling with this piece of sql - Basically I want to update a column called output in table A (fileid, output) based on what is set to true on a similar column in Table b.(fileid, outname, sitename)

I've tried to do it with joins but no luck - any ideas on where I should be going with this?

UPDATE tableA A INNER JOIN tableB B ON A.FileId = B.FileID
SET A.[Output] = True
where (A.FileId = B.FileId) and (B.SiteName = 'PP') and (B.[output] = True);

Thanks,
e.

 

[JerryKlmns]

elpico, change your

where (A.FileId = B.FileId) and (B.SiteName = 'PP') and (B.[output] = True);

to

where ((B.SiteName = 'PP') and (B.[output] = True));

 

[mp9]

Try this:

UPDATE A INNER JOIN B ON A.FileID = B.FileID
SET A.[Output] = True
WHERE B.SiteName="PP" AND B.[Output]=True;

Hope this helps.

http://www22.brinkster.com/accessory/

 

[elpico]

Nice one - works a treat - was silly of me to try and build a relationship when I already have it in the JOIN!

Thanks,
e.