Query Builder Union Support
hi guys
a simple UNION like
SELECT TOP 10 contactnumber FROM contacts c JOIN addresses a ON c.addressnumber = a.addressnumber
UNION
SELECT TOP 10 contactnumber FROM contacts c JOIN addresses a ON c.addressnumber = a.addressnumber
will create an error "1 Not unique table/alias: 'c' Query.sql".
It would be nice to see the querybuilder processing these kind of sql's.
kind regards
peter
8
votes
Peter
shared this idea