Re: New to Oracle
- From: "Mike Enarson" <menarson@xxxxxxx>
- Date: Tue, 27 Dec 2005 16:16:57 -0600
"Steven Kondolf" <skondolf@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:cb3oq1pmpi0b10a844v4g5eeg425n899ir@xxxxxxxxxx
> On Wed, 21 Dec 2005 21:13:32 -0800, "Jim Kennedy"
> <kennedy-downwithspammersfamily@xxxxxxxxx> wrote:
>
>>
>><inlove22@xxxxxxxxxxx> wrote in message
>>news:1135216259.818266.149110@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>> Hello! Wondering if someone can help educate me on the design on query
>>> that i would like to run.
>>>
>>> Table A Table B
>>> ID PAR_ID
>>> X_ROW_1 X_ROW_3
>>> .. ..
>>> .. ..
>>>
>>> Table A and B are linked by the ID and PAR_ID columns. So i need a
>>> select statement that queries for all records that contain the non null
>>> values of x_row_3 along with all the non_null values of x_row_1.
>>> Sort of something like this. I know its some type of join but i can
>>> get it to work.
>>>
>>> x_row_1 x_row_3
>>> 2343 234523
>>> 234324
>>> 5645
>>> 979779
>>>
>>
>>select a.x_row_1,b.x_row_3 from table_a a, table_b b where a.id=b.par_id
>>and
>>a.x_row_1 is not null and b.x_row_3 is not null
>>
>>Jim
>>
> I think you have to change the 'and' to 'or' in the select. If you
> don't, you'll only get one row returned.
It looks to me like you need to go with an outer join, instead of an inner
join.
It seems you are looking for all of the non null values from both columns.
Regards
Mike Enarson
.
- References:
- New to Oracle
- From: inlove22
- Re: New to Oracle
- From: Jim Kennedy
- Re: New to Oracle
- From: Steven Kondolf
- New to Oracle
- Prev by Date: Re: Supply Date based on DOW
- Next by Date: Re: New tool for database developers, DBAs and analysts!
- Previous by thread: Re: New to Oracle
- Next by thread: problems on views
- Index(es):
Relevant Pages
|
|
