Re: [cobalt-users] mysql query question

["DenIT Internet Services [Thijs]" <thijs@xxxxxxxxx>]

Thats what I meant to say ;-)

Thijs


> 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
> 
> 
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>