Hi Justy,

>Thank you for your reply! I haven't try and didn't know how to use UNION on SQL command. Could you mind to show me the sample code based on my case? Thanks a lot!!!

SELECT FieldA AS FieldSQL ;
   FROM TableA ;
UNION SELECT FieldB AS FieldSQL ;
   FROM TableA ;
UNION SELECT FieldC AS FieldSQL ;
   FROM TableA ;
INTO TABLE TableB

HTH,