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