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