filter distinct values based on 3 or more names (was "Hectic Query HELP")
Hi all any idea how to write a query to successfully achieve this ? I need a query that brings back all the distinct values for ALL the values in the table and then filters those distinct values based on 3 or more names :
SELECT Distinct SerialNumber, SMSDateStamp,
OperatorID FROM smslog where smslog.operatorid IN
(Select operatorid from smslog where operatorid IN('BON','EVAS','WIL2'))
Something like this but this query causes mysql to crash because its very wrong I am sure.
HELP ! any ideas will be appreciated.