update query??? HELP!!!

From: Janet Linsy <janetlinsy_at_yahoo.com>
Date: Wed, 14 Nov 2001 15:14:08 -0800
Message-ID: <F001.003C5301.20011114145536@fatcity.com>

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). Received on Wed Nov 14 2001 - 17:14:08 CST