Search results

FYI: I kept that statement as a subquery because this is the actual statement I am using in my database: SELECT DISTINCT UnionTable.Name, UnionTable.EmpNumb FROM ( SELECT Name, 99999 AS EmpNumb, 1 AS Origin FROM [SS Driving] UNION SELECT Name, 99999 AS EmpNumb, 2 AS Origin FROM [SS Training]...

Thanks, that did help. Another question for you... Do you know why this works: SELECT * FROM ( SELECT 1 AS num, 'abc' AS str FROM Events UNION SELECT 3 AS num, 'abc' AS str FROM Events UNION SELECT 9 AS num, 'xyz' AS str FROM Events ) ; But this gives an error "Syntax error in JOIN...

The following query works without a problem: SELECT * FROM ( SELECT Name, 99999 AS EmpNumb, 2 AS Origin FROM [SS Training] ) UNION ALL ( SELECT Name, EmpNum AS EmpNumb, 3 AS Origin FROM [JS Driving] ) However this query gives an error: "The number of columns in the two selected tables or...