[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
>