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

<inlove22@hotmail.com> wrote in message
news:1135216259.818266.149110@g43g2000cwa.googlegr oups.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

On Wed, 21 Dec 2005 21:13:32 -0800, "Jim Kennedy"
<kennedy-downwithspammersfamily@attbi.net> wrote:

>
><inlove22@hotmail.com> wrote in message
>news:1135216259.818266.149110@g43g2000cwa.googleg roups.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.

"Steven Kondolf" <skondolf@nospam.rochester.rr.com> wrote in message
news:cb3oq1pmpi0b10a844v4g5eeg425n899ir@4ax.com...
> On Wed, 21 Dec 2005 21:13:32 -0800, "Jim Kennedy"
> <kennedy-downwithspammersfamily@attbi.net> wrote:
>
>>
>><inlove22@hotmail.com> wrote in message
>>news:1135216259.818266.149110@g43g2000cwa.google groups.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