Thanks!
I'll try it.
>SELECT a.Member_Id, a.Name, a.email, b.Subject, b.Message ;
> FROM TableA a, TableB b ;
> WHERE a.member_id = b.Member_Id ;
> ORDER BY 1, 4, 5
>
>Note the use of column numbers to specify the order.
>
>Regards
>Mark
If you have a chance to visit Korea, Be my Guest.
rexall