Re: Simple (?) insert problem

Thanks for all replies I have now figured out how to do it using insert into table < fields>
select <fields> from table
where..........

It was the mapping of the fields I got lost with!

Alex

On Mon, 22 Nov 1999 16:49:16 GMT, alex_at_alenda.freeserve.co.uk (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
Received on Tue Nov 23 1999 - 05:43:56 CST