Thanks for the response.
After looking at the mysql docs I realized that what I wanted is "intersect" rather than "union", but intersect will only be implemented in future versions. In the meantime, how do I select into a new table or make a temporary table.
Hello All,
If I have two select statements which both outputs a column called name and number of times the name appears and I would like to know what names appear in both results, how do I query for that?
Example - Select 1 output = {paul 3, joe 1, tommy 4}
Select 2 output = {paul 2...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.