update PhoneArea set (AREAID,CARDTYPEID) = (select Area.AREAID,CardType.CARDTYPEID from Area, CardType where PhoneArea.CITY = Area.NAME AND length(Area.AREAID) > 4 AND PhoneArea.CARDTYPE = CardType.CARDTYPENAME) where exists (select 1 from Area, CardType where PhoneArea.CITY = Area.NAME AND length(Area.AREAID) > 4 AND PhoneArea.CARDTYPE = CardType.CARDTYPENAME)
Area, CardType where PhoneArea.CITY = Area.NAME AND length(Area.AREAID) > 4 AND
PhoneArea.CARDTYPE = CardType.CARDTYPENAME)
where exists (select 1 from Area, CardType where PhoneArea.CITY = Area.NAME AND length(Area.AREAID) > 4 AND PhoneArea.CARDTYPE = CardType.CARDTYPENAME)