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,
Bill Armbrecht
VFP MCP