Keith,
> I got it! What you said about replacing one JOIN with another is what did
> the trick. After a little trial and error (maybe a little more than a
> little) I got the results I needed. Thanks for the help. In case you're
> still curious I am modeling short track racing here in New Yor
Try to delete the index (drop index) of the table!
I had the problem and solved this this way.
regards,
Andreas
On Samstag, Februar 9, 2002, at 11:41 Uhr, DL Neil wrote:
> Keith,
>
>> I have the below query that returns the correct records but the
>> POINTFUND.description field is all NULL
ebruary 09, 2002 5:42 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Table appears in multiple joins returns null column
Keith,
> I have the below query that returns the correct records but the
> POINTFUND.description field is all NULL while it has values in the table.
&g
re values in POINTFUND.TYPE_ID that match TYPES.TYPE_ID. The obvious
> solution to this is to create a query that joins POINTFUND and TYPES and
> then use that query in the above query insead of the POINTFUND table (I hope
> that makes sense). Unfortunatelly there doesn't seem t
Keith,
> I have the below query that returns the correct records but the
> POINTFUND.description field is all NULL while it has values in the table.
> Any idea why? Thanks.
>
> SELECT
>
> RACES.RACE_ID,
> RACES.sequence,
> TYPES.typelong,
> SCHEDULE.event,
> SCHEDULE.date,
> PARTY.lname,
> POINT
Try to delete the index (drop index) of the table!
I had the problem and solved this this way.
regards,
Andreas
On Samstag, Februar 9, 2002, at 11:41 Uhr, DL Neil wrote:
> Keith,
>
>> I have the below query that returns the correct records but the
>> POINTFUND.description field is all NULL
Keith,
> I have the below query that returns the correct records but the
> POINTFUND.description field is all NULL while it has values in the table.
> Any idea why? Thanks.
>
> SELECT
>
> RACES.RACE_ID,
> RACES.sequence,
> TYPES.typelong,
> SCHEDULE.event,
> SCHEDULE.date,
> PARTY.lname,
> POINT
