Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: New to Oracle
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.
Received on Fri Dec 23 2005 - 08:46:13 CST