UNION ALL just doesn't work here :( why?
plz see these PICs: "first" and "second" tables I'm supposed to have are given by: https://app.box.com/s/5a95bbb3hmquwrk4b7b7dzi1evz34loi I created these same exact tables: https://app.box.com/s/5a95bbb3hmquwrk4b7b7dzi1evz34loi https://app.box.com/s/2p01nzzht9i6jjzhf2dyvjk8nmsmcorb Now, the SQL query itself I do is: https://app.box.com/s/6n69eka4yu7tnijiazayk292hkm7iplf [Oh, and BTW, hovering my mouse over that cross in the red circle on the left of the middle line just tells me: Unrecognized statement type. (near ALL)] Running my SQL query then gives: https://app.box.com/s/u2ic9nph6wunilhiq6jsd9mwlbz4ke6s which sadly fails to match what they got: https://app.box.com/s/h9a5ot7goj8tdef6h7zt05pxf9y98mm5 just can't see where exactly I'm going wrong - why???!! :((( Big thanks! :)