[thelist] ASP.NET: UNION query not returning expected results

Joel D Canfield joel at streamliine.com
Thu Sep 27 15:27:43 CDT 2007

> i think the UNION that you wrote is awfully convoluted for what it's 
> supposed to return, and should be simplified

hey, we're all surprised by *that*, aren't we?

any pointers or suggestions (or complete copy-and-paste magic solutions)

I haven't a clue for some reason how to write the select/union more

Just to be sure we're thinking in the same place (sort of)

    Employees table has (among others) fields named id and officeid
    Offices has id and number

I need a list of office ids and numbers where Employees.id is (my
current querystring value) and Offices.id doesn't appear in


More information about the thelist mailing list