Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- I can't see the wood for the trees.

jecasc - 9:52 pm on Feb 15, 2011 (gmt 0)


I think what your statement does is return all unique COMBINATIONS of FaultType and ID.

Actually I think you can't limit DISTINCT to one of the columns in your SELECT query.

[edited by: jecasc at 9:53 pm (utc) on Feb 15, 2011]

Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4267598.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com