Re: update query??? HELP!!!

update SERVICE_LOCATION a set CENTRAL_OFFICE_CODE =

         (select FRANCHISE_NAME
         from  FRANCHISE_AREA c, SERVICE_LOC b   where
                 a.SERVICE_LOCATION_ID = b.SERVICE_LOCATION_ID and
                 b.FRANCHISE_ID = c.FRANCHISE_ID)

At 02:55 PM 11/14/01 -0800, you wrote:
>Hi all,
>
>How to do this query, I have three tables:
>SERVICE_LOCATION a, SERVICE_LOC_AREA b, FRANCHISE_AREA
>c.
>
>The relationship between them is:
>a.SERVICE_LOCATION_ID = b.SERVICE_LOCATION_ID and
>b.FRANCHISE_ID = c.FRANCHISE_ID
>
>I need to update CENTRAL_OFFICE_CODE column in table
>SERVICE_LOCATION a, using a value selected from
>FRANCHISE_AREA c. a and c are related through b.
>
>update SERVICE_LOCATION set CENTRAL_OFFICE_CODE =
> (select FRANCHISE_NAME
> from FRANCHISE_AREA)
>where
>a.SERVICE_LOCATION_ID = b.SERVICE_LOCATION_ID and
>b.FRANCHISE_ID = c.FRANCHISE_ID)
>
>I don't know where to specify a, b, c tables.
>
>Thank you!
>
>Janet
>
>
>
>__________________________________________________
>Do You Yahoo!?
>Find the one for you at Yahoo! Personals
>http://personals.yahoo.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Janet Linsy
> INET: janetlinsy_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Regina Harter
  INET: rharter_at_emc-inc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).