Queries of this type are not supported

[Jane]

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

[Gerben Kessen]

See the post of Fred in microsoft.public.fox.vfp.queries-sql.

Post by Jane
Hi there,
I have a query, when I test it in the command window, I get the error
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