Unanswered: Statement converting Columner to Tabular
I'm building a website for my local hockey league and need to do something that I'm not sure can be accomplished with a SQL statement.. I have two tables with the following fields relevant to my question:
It's the same data, just shown differently. I can get what I need by adding a third table to the mix, but that entails extra data entry. It would be much nicer to have a SQL statement that shows me columner data in the tabular format (or vice versa)..
(sorry for the goofy attempt at showing data, I'm not sure how to show it correctly here..)