Benedikt Schackenberg wrote:
Am 02.01.2010 13:43, schrieb bharani kumar:
No Duplicate records,
select hospital1code from *yourtable* grop by hospital1
This won't work as he's also looking for entities in the hospital2code
and hospital3code fields to be returned in the same resultset, but as a
single column. Essentially, hospital1code, hospital2code and
hospital3code need to be merged to a single column, deduped, and then
returned.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
