I have a query like this:
SELECT DISTINCT Channel, ChannelType, Source FROM ChannelStatus;
Each channel is supposedly listed in this table only 1 time, but just in case,
what I really want to do is make sure that no channels are duplicated. Is
there some way to make the keyword "DISTINCT" apply to Channel only? Sort of
a shortcut to (example in pseudocode, although it'd be in Perl):
SELECT DISTINCT Channel FROM ChannelStatus;
FOR EACH Channel
SELECT Channel, ChannelType FROM Source WHERE Channel = 'channel'
ENDLOOP
Thanks!
Hal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
