Queries of this type are not supported

From: Jane (Jane_at_discussions.microsoft.com)
Date: 08/06/04


Date: Thu, 5 Aug 2004 20:47:03 -0700

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.
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.queries-sql)
  • Re: Queries of this type are not supported
    ... SELECT Endorsement.*, Repercentage.*; ... Microsoft Visual FoxPro MVP ... > I have a query, when I test it in the command window, I get the error ...
    (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)
  • 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)