Update multiple fields on table based on value in another table

[fatherofthree]

I am kind of new to SQL programming.
I am trying to update multiple fields on a table based on criteria in another table. See code below:

UPDATE SHIP
   SET SHIP.DETACHED_HOUSE = 0, SHIP.ATTACHED_HOUSE = 0,    SHIP.PUD = 0, SHIP.CO_OP = 0, SHIP.CONDO = 1
   WHERE SHIP.AP_NUM = (SELECT T.AP_NUM FROM T WHERE        T.PROPERTY_TYPE  IN('CONDO', 'CONDO-HIGH', 'CONDO-LOW'))

I keep getting the following error:

Error number: -1427, position: 0-
ORA-01427: single row subquery returns more than one row

I understand why I get the error but I am having trouble getting past it to reach my goal.

Any help would be appreciated.

Thanks

Chad

 

[lewisp]

Try changing your first WHERE clause to

[tt]WHERE SHIP.AP_NUM IN (SELECT T.AP_NUM FROM T...[/tt]

Does that give the desired result?

 

[fatherofthree]

That is what I just figured out. Yes it does work.

Thanks

Chad