How can I find only "NON NULL" & "NON ZERO" values with MySQL when using "GROUP BY"?
Specifically, let's say that I have following data in a table 'foo'.
id name fkid
1 a NULL
2 a 0
3 a abc
4 a 0
I want to have "a - abc" from the above table data using a single query and using "GROUP BY" without using any field conditions like "fkid <>" or "fkid = ". Can anyone please help me? I need it urgently. Thanx in advance.
