Multiple WHERE clause for each column?
View Single Post
11-01-2009, 10:22 PM
is cute and cuddly
Join Date: Mar 2008
Location: Vegas, Baby
Won't work either, because the data returned in each column differs when you change the WHERE clause, so the UNION creates multiple groups for each timestamp.
If I then went one step further and created a virtual table using unions and grouped the results of that data, it would be severely skewed, as it would add columns that it's selected twice, so I'm not sure that UNION is the answer here.
View Public Profile
Send a private message to delayedinsanity
Visit delayedinsanity's homepage!
Find More Posts by delayedinsanity