RE: [cobalt-users] mysql query question

[<support@xxxxxxxxxxxxx>]

Hi Thijs

The correct syntax would be:

SELECT aa, bb, cc FROM TT WHERE cc IS NOT NULL;

regards/vriendelijke groeten

Erik Venema
DutchNet
Postbus 3, 3734 ZG  Den Dolder
www.dutch-net.com

-----Original Message-----
From: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of DenIT Internet
Services [Thijs]
Sent: woensdag 26 september 2001 8:59
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: Re: [cobalt-users] mysql query question


You're missing FROM TT in that query.

Regards,
 Thijs


> this maybe a beginner question, but i am a beginner.
> 
> say, i have 3 fields, aa, bb, and cc in my table TT
> i need to get the results where cc is not null.
> so my query will be: SELECT aa, bb, cc WHERE cc IS NOT NULL.
> i think it's correct, but it doesn't work, why?
> 
> help appreciated
> 
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
> 

_______________________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To Subscribe or Unsubscribe, please go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users