How To Update Field in One Table Based on Value in Another Table

[byrne1]

Here's the SQL code that I have so far that does not work:

UPDATE ITEM SET webflag='' where itemnum=(select itemnum from itmdescr where description1='')

Basically, I want to set the webflag field to <blank> for any items whose description1 field is blank.

Any suggestions? TIA!!

 

[PHV]

You may try this:
UPDATE ITEM INNER JOIN itmdescr ON ITEM.itemnum=itmdescr.itemnum
SET webflag=''
WHERE description1=''

Or this:
UPDATE ITEM SET webflag='' where itemnum In (select itemnum from itmdescr where description1='')

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