Thanks Cheang,
That seemed to be just what I needed.
Mike
>Will this help?
>
>
>Select CommonField From Table1 ;
>Union ;
>Select CommonField From Table2 ;
>Union ;
>Select CommonField From Table3 ;
>Group By CommonField
>
>
>Wan
>
>>Hi all Fox SQL gurus,
>>
>>I have three tables with a common field name and type (Char 4). I'd like to determine all unique values from all three tables using a SQL select statement. I believe that it will require unions of select statements. Can this be done and if so how?
>>
>>TIA,
>>
>>Mike