I ran this command against our live system, and received back the
-WARNING- No rows exist or satisfy the specified clause.
message (thank heaven! They had better match!)
SELECT t1.SONO,MAX(t1.INV_AMT),SUM(t2.TSALE$) +
FROM SaleOrdr t1, SaleTran t2 +
WHERE t1.SONO = t2.SONO +
GROUP BY t1.SONO +
HAVING MAX(t1.INV_AMT) <> SUM(t2.TSALE$)
MJS <[EMAIL PROTECTED]> wrote:
>I did, same error. I don't think I have a corrupt database, but I may have to
>create a mini database to track this down. Can you write and test a 1 line
>command that you know works on one of your data bases and email it to me?
>
>TIA!
>
__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the
convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/
Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
