SELECT from the EVENTS table doesn't look right.

Subject:	SELECT from the EVENTS table doesn't look right.
From:	paul baines <paulbaines AT HOTMAIL DOT COM>
Date:	Fri, 22 Sep 2000 12:31:13 GMT

Hello,

Can anyone explain the following results to me?

tsm: TEST>select count(*) from events

Unnamed[1]
-----------
       117
       117

tsm: TEST>select count(*) from events where '08/01/2000' < scheduled_st
                  art

Unnamed[1]
-----------
      8507
      8507


It seems as if by narrowing down my selection I get more results. This seems
to be behaving like a Q EVENTS rather than SQL.


Confused of Frankfurt.


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.

<Prev in Thread]	Current Thread	[Next in Thread>
SELECT from the EVENTS table doesn't look right., paul baines <= Re: SELECT from the EVENTS table doesn't look right., Andy Raibeck

Previous by Date:	Re: 3.1 client support after January 2001, Richard Sims
Next by Date:	Re: restoring files from another machine, Richard Sims
Previous by Thread:	HSM error, Nalda Aliende, Eva
Next by Thread:	Re: SELECT from the EVENTS table doesn't look right., Andy Raibeck
Indexes:	[Date] [Thread] [Top] [All Lists]