Re: Union All not working

[Daniel Paquin]

Thanks Phil for your help.

It worked and I now have the expected results.

"you might want to combine these together into a single table, but given that you created one from the other, that would probably give you duplicate keys ... and that would be Bad."

You are correct that this would create duplicate keys. In normal circomstances this would be bad. However, this is the end result of multiples select to create some kind of dissemination table.

Now I am in a position where I only have to query a single table without having to do a single join. Select and display nothing else. If needed I do have a table which contains unique records which can be link to this table if required i.e a one to many relationship.

Many thanks for your help!

I am new in using mySQL, I am looking a lots of video tutorials before posting on this site. I was really stuck and now I can advance further.