SQL SELECT DISTINCT two tables?

[oxide54]

So whats wrong with this?

 

SELECT DISTINCT PSUEDOFIELD_2 FROM (SELECT FIELD2 AS PSUEDOFIELD_2 FROM TABLE2 WHERE CURRENT=1 UNION ALL SELECT FIELD1 AS PSUEDOFIELD_2 FROM TABLE1) WHERE PSUEDOFIELD_2 IS NOT NULL AND PSUEDOFIELD_2 <> '' AND PSUEDOFIELD_2 <> ' ';

 

this gives me rows? but the PSUEDOFIELD_2 is not distinct ???

Edited October 28, 2012 by oxide54

[oxide54]

ignore me, its whitespace differences

[oxide54]

ANSWER

 

SELECT DISTINCT PSUEDOFIELD_2 FROM (SELECT LTRIM(RTRIM(FIELD2)) AS PSUEDOFIELD_2 FROM TABLE2 WHERE CURRENT=1 UNION ALL SELECT LTRIM(RTRIM(FIELD1)) AS PSUEDOFIELD_2 FROM TABLE1) WHERE PSUEDOFIELD_2 IS NOT NULL AND PSUEDOFIELD_2 <> '' AND PSUEDOFIELD_2 <> ' ';