From: Rob on 12 Nov 2009 12:53
That worked! Thank you so much. Great idea...it never occurred to me to use the MAX function with a string.
Plamen Ratchev wrote:
You can do:SELECT PersonID, MAX(IMadd), MAX(EmailAdd), MAX(Phone)FROM ...
You can do:
SELECT PersonID, MAX(IMadd), MAX(EmailAdd), MAX(Phone)
GROUP BY PersonID;
Previous Posts In This Thread:
EggHeadCafe - Software Developer Portal of Choice
Refactoring with the Parameterized Factory Pattern
Prev: SQL syntax (part 2)
Next: SQL optimisation, stop the sub query as soon as an error is found