Re: Simple (?) insert problem

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 22 Nov 1999 17:18:28 +0800
Message-ID: <38390A64.6D1C@yahoo.com>

Alex Hudghton wrote:
>
> I know that I can do :
>
> Insert into <table>
> select <fields> from < other table>
> where .......
>
> However, I have one table like this:
>
> SQL> desc pkmstest.aiinvn00
> Name Null? Type
> ------------------------------- -------- ----
> AI00_WAREHOUSE NOT NULL CHAR(3)
> AI00_LOCATION_TYPE_FLAG NOT NULL CHAR(1)
> AI00_PHYSICAL_INV_CODE NOT NULL CHAR(4)
> AI00_PHYSICAL_COUNT_SEQ_NBR NOT NULL NUMBER(1)
> AI00_LOCATION NOT NULL CHAR(24)
> AI00_CASE_NBR NOT NULL CHAR(20)
>
> and the other like this :
>
> SQL> desc pkmstest.afinvn00
> Name Null? Type
> ------------------------------- -------- ----
> AF00_WAREHOUSE NOT NULL CHAR(3)
> AF00_LOCATION_TYPE_FLAG NOT NULL CHAR(1)
> AF00_PHYSICAL_INV_CODE NOT NULL CHAR(4)
> AF00_LOCATION NOT NULL CHAR(24)
> AF00_CASE_NBR NOT NULL CHAR(20)
>
> As you can see the fields have the same name apart from the prefix of
> the table name. Is there any way round this ??
>
> Regards
>
> Alex

Sorry but what is the problem here - are you trying to copy rows from to another ? insert/select will work here will no problems...

Please explain more ...

Cheers
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Nov 22 1999 - 03:18:28 CST