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