Queries of this type are not supported
From: Jane (Jane_at_discussions.microsoft.com)
Date: 08/06/04
- Previous message: Sorin Sandu: "Re: SQLEXEC problem"
- Next in thread: Fred Taylor: "Re: Queries of this type are not supported"
- Reply: Fred Taylor: "Re: Queries of this type are not supported"
- Reply: Anders: "Re: Queries of this type are not supported"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 5 Aug 2004 20:51:01 -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. Thanks
in advance!
Cheers
Jane
- Previous message: Sorin Sandu: "Re: SQLEXEC problem"
- Next in thread: Fred Taylor: "Re: Queries of this type are not supported"
- Reply: Fred Taylor: "Re: Queries of this type are not supported"
- Reply: Anders: "Re: Queries of this type are not supported"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
