Suppose that I have a dummy table named, Dummy, and it has a column name
Status, which can contain values Neg, or Pos.
If I have the following data in table, Dummy:
id, status
1 Neg
2 Neg
3 Pos
4 Neg
I need to write a query returns the count of number of Neg in status but
filters out everything even if there is one Pos value in the column. So
in this case, there will be nothing returned since there is Pos in row 3.
I know I can work backward by selecting on status = Pos and if there is
a record returned, I can dump all the results but I would prefer a
solution that will return nothing if Pos is found in one of the records.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
