I am really struggling to find an answer to this question. I have created a concatenated table by pulling data from two different ODBC connections. Now I want to select distinct from this newly created table. I cannot get this to work and can't believe how hard it has been to do something so simple. Please somone out there let me know, what am I doing wrong?