Re: New to Oracle

"Steven Kondolf" <skondolf_at_nospam.rochester.rr.com> wrote in message news:cb3oq1pmpi0b10a844v4g5eeg425n899ir_at_4ax.com...
> On Wed, 21 Dec 2005 21:13:32 -0800, "Jim Kennedy"
> <kennedy-downwithspammersfamily_at_attbi.net> wrote:
>
>>
>><inlove22_at_hotmail.com> wrote in message
>>news:1135216259.818266.149110_at_g43g2000cwa.googlegroups.com...
>>> 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 Received on Tue Dec 27 2005 - 16:16:57 CST