Maybe what he wants is more like:

SELECT Card_ID, Status, Date from table1 union select card_id, status, date from table2 into cursor temp

* that will get the unique records from both tables, but will only consider the three fields, instead of the entire record.



>>Hi,
>> I have tried to use your idea, but it doesn't return result in distinct format. Any suggestion?
>>
>>Thank you
>
>Well, then revert to your original solution or just select * distinct from the first cursor, i.e.
>
>select * from first_table ;
> union select * from second_table;
> into curs temp
>
>select * distinct from temp into curs distinct_cursor