Re: picking up a single record from merge table, if it has duplicate entries

Ilavajuthy Palanisamy wrote:
> Hi,
>
>  
>
> Currently we have multiple MYISAM tables, we create merge table out of
> these multiple tables to retrieve data.
>
> Now we have same record available in multiple tables, data retrieved
> from merge table produces duplicate records.
>
> But what we need is to get only one record out of these multiple records
> based on some condition.
>
>   
[chop]
Does select distinct... not work in your example?
Rich