Looks like you have to have a function, even if it's arbitrary, to make it work.
Anybody else know anything different?
Albert Berry wrote:
> 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/
