Ted Roche wrote:
Clear as mud?Totally. Do you want a RANDOM value from each table, or one that appears only once? SELECT MyField, COUNT(MyField) AS TheCounter FROM MyTable WHERE {blah blah blah} GROUP BY MyField HAVING TheCounter =1
Each record and field from the table, plus an additional unique value. It doesn't need to be random, only guaranteed unique. But needs to be generated by the query, NOT by modifying the table.
Nothing critical, but would make my life a lot easier if such a critter exists.
_______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
