How about:
insert into table3(company_id,lev_id,vare_id)
(select table2.company_id,lev_id,vare_id
from table1, table2
where table1.company_id = table2.company_id);
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
Life is like a sewer, what you get out of it depends on what you
insert into table3(company_id,lev_id,vare_id)
select company_id,lev_id,vare_id from table2 where vare_id = 56
AND exists (select 1 from table1 where table1.company_id =
table2.company_id)
On Thu, 2003-10-16 at 10:20, [EMAIL PROTECTED] wrote:
Hallo,
Anyone whom could gve me some good
SQL select * from test1;
COMPANY_ID
--
16
45
50
SQL select * from test2
2 ;
COMPANY_ID LEV_IDVARE_ID
-- -- --
16 45 56
34 10 20
67 10 20
45
Ahh maybe I read it a little wrong then... ;D
-Original Message-
Quintin, Richard
Sent: 16 October 2003 15:49
To: Multiple recipients of list ORACLE-L
insert into table3(company_id,lev_id,vare_id)
select company_id,lev_id,vare_id from table2 where vare_id = 56
AND exists
Well, not quite sure what the requirement is here - in the first instance
try
select code, id from table_name group by code, id;
or you could get a bit more info with
select code, id, count(*) from table_name group by code, id;
... and those results may give you some ideas.
peter
Hi
If you do : select distinct code || ' ' || id, city, year ...
Regards
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 9 juillet 2003 14:35
À : Multiple recipients of list ORACLE-L
Objet : Question about sql
Hallo,
I would like to pick
Not directly, but a with little sed/awk/grep etc you
could turn a template control file into a version
ready for use.
hth
connor
--- [EMAIL PROTECTED] wrote: Hallo all you
gurus,
I have a question:
Is it possible that every time the sql loader
script runs change the field names to the