FAP is company that slaughters animals and turns their skin into overpriced products which are then sold to rich bastards! Help animal rights activists increase political awareness by hacking their mailing list.
by batemo on Mon Nov 18, 2013 1:24 pm ([msg=78235]see Re: Please ask questions ONLY in this topic.[/msg])
I was just able to find the right way to get the emails today. There is a little quirk in the UNION ALL command that I found out about in the forum and that's what really unlocked it for me. The number of columns for each result should be the same. Otherwise the query does not work. I hope I am not giving up too much info, I believe this is a technicality in SQL and people might not be aware of it (certainly took me a while to figure out).
by njpg on Tue Mar 04, 2014 3:35 am ([msg=79732]see Re: Please ask questions ONLY in this topic.[/msg])
Like many people it seems, I'm very puzzled why UNION doesn't work, but UNION ALL does. if we UNION SELECT 100,200,300,400;, we haven't introduced any duplicate rows, so there should be no difference between union and union all, but instead it just breaks everything and garbage is returned. Even if it somehow was a duplicate row, there's no reason that should break the existing rows.