Re: Queries of this type are not supported

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Fred Taylor (ftaylor_at_mvps.org!REMOVE)
Date: 08/06/04 

Date: Thu, 5 Aug 2004 22:17:55 -0700

Try this:

SELECT Endorsement.*, Repercentage.*;
                 FROM endorsement, repercentage;
                WHERE Repercentage.rp_number = endorsement.en_renumber ;
                                 AND Repercentage.rp_effectivedate IN ;
                                          (SELECT max (rp.rp_effectivedate)
;
                                                            FROM
Repercentage rp, Endorsement ed ;
                                                            WHERE
Ed.en_renumber = rp.rp_number;

AND rp.rp_effectivedate <= ed.en_startdate);

Fred
Microsoft Visual FoxPro MVP

"Jane" <Jane@discussions.microsoft.com> wrote in message
news:26A4343A-12D6-45EC-993A-8F282A2763D2@microsoft.com...
> Hi there,
>
> I have a query, when I test it in the command window, I get the error
> message: Queries of this type are not supported. My query is:
> SELECT Endorsement.*, Repercentage.*;
> FROM endorsement, repercentage;
> WHERE Repercentage.rp_number = endorsement.en_renumber ;
> AND Repercentage.rp_effectivedate = (SELECT max(rp.rp_effectivedate) FROM
> Repercentage rp;
> WHERE Endorsement.en_renumber =
> rp.rp_number;
> AND rp.rp_effectivedate <=
> Endorsement.en_startdate);
>
> What can I do? It's urgent, I have to finish it as soon as possible.
Thanks
> in advance!
> Cheers
> Jane
>

Relevant Pages

  • Queries of this type are not supported
    ... I have a query, when I test it in the command window, I get the error ... Queries of this type are not supported. ... SELECT Endorsement.*, Repercentage.*; ...
    (microsoft.public.fox.vfp.dbc)
  • Queries of this type are not supported
    ... I have a query, when I test it in the command window, I get the error ... Queries of this type are not supported. ... SELECT Endorsement.*, Repercentage.*; ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: Queries of this type are not supported
    ... A correleated subquery must correlate to itself. ... FROM endorsement E join repercentage R; ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: Queries of this type are not supported
    ... > I have a query, when I test it in the command window, I get the error ... > FROM endorsement, repercentage; ...
    (microsoft.public.fox.vfp.dbc)