Re: New to Oracle

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 21 Dec 2005 21:13:32 -0800
Message-ID: <QYGdnQsFyd0MqDfenZ2dnUVZ_tqdnZ2d@comcast.com>

<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 Received on Wed Dec 21 2005 - 23:13:32 CST