Originally Posted by Old Pedant
FWIW, you could have tried my query in some standalone query tool (e.g., phpmyadmin or whatever it is called) without using your own PHP code. That would have shown you what the query is doing. And whether or not I had it right.
Thanks for the tip
that occurred to me.. seeing the results helped a tad.. but the aliases (and the nested query in there) was new to me.. so i wanted to learn exactly how the command structure was creating those results..
still a little foggie on it.. but i do think i understand now.. recreating it in another situation may be difficult for me.. but at least thats another building block to a decent foundation of understanding.