Re: easy in Access, but not in Oracle (query)

From: R Fray <russ_at_u-net.net>
Date: Fri, 02 Oct 1998 11:20:45 GMT
Message-ID: <3614b6e8.76722188@news.u-net.com>

On Fri, 02 Oct 1998 06:31:41 -0400, Kevin Kirkpatrick <kjk_at_hrb.com> wrote:

>I have what will probably be an easy question to answer. Yesterday I
>needed to update a table based on another table. Something like:
>
>table1 table2
>
>id id
>name address
>address
>
>What I was trying to do is move the address field of table2 into the
>address field of table1. For some reason I wasn't able to do it in
>oracle. I linked up to the database thru MS-Access and was able to do
>it with Access. So, that kinda says that it can be done, but when I
>used a similar sql query in oracle (same as the one MSAccess produced,
>it still did not work. What would be the format for the UPDATE? A
>

Rather than write a query for you from scratch, show us the query that has been produced and we can pick at the code ;) that Access has produced.

Russ.

Russell Fray
U-NET Ltd. Received on Fri Oct 02 1998 - 06:20:45 CDT