Re: How to write this sql urgent...

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 25 Jan 2010 19:15:08 +0100
Message-ID: <4b5ddfab$0$24604$426a74cc_at_news.free.fr>


"JIACHENG SUN" <sunjcb_at_googlemail.com> a écrit dans le message de news: 3bd2a321-7907-4709-8267-4aa3fe012694_at_o28g2000yqh.googlegroups.com...
| right..
|
| create table AA
| (
| C_1 VARCHAR2(50) not null,
| C_2 VARCHAR2(4000) not null,
| C_3 VARCHAR2(4000),
| C_4 VARCHAR2(4000)
| );
|
| insert into table aa values (1, code1, null, null);
| insert into table aa values (1, code2, null, null);
| insert into table aa values (2, code3, null, null);
| insert into table aa values (2, code5, null, null);
|
| create table AAA
| (
| C_1 VARCHAR2(50) not null,
| C_2 VARCHAR2(4000) not null,
| C_3 VARCHAR2(4000),
| C_4 VARCHAR2(4000)
| );
|
| insert into table aa values (code1, 5.5, null, null);
| insert into table aa values (code2, 3.5, null, null);
| insert into table aa values (code3, 0.00, null, null);
| insert into table aa values (code4, 0.00, null, null);
| insert into table aa values (code5, 0.00, null, null);


Good, now what is the rule you want to apply to come from your tables and data to the result you posted? Is this just a cartesian product?
What is the EXACT and COMPLETE result with the above data?

Regards
Michel Received on Mon Jan 25 2010 - 12:15:08 CST

Original text of this message