LifeinAsia - 9:52 pm on Sep 12, 2012 (gmt 0)
So I want to display all rows from the column category. And yes, I need the WHERE code in there.
If you want to display all rows regardless of the values of the Category field, you do NOT need the WHERE clause.
If you want to show all the rows except where the Category field has no value, then use:
WHERE Category IS NOT NULL