You're welcome.
>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