prefixing column names in return from SQL JOIN

[eluser]champs[/eluser]
Use aliases. Please. Alias every table reference and join the tables by their aliases. I'm not going to rehash every time it comes up, but as a pet issue of mine, you'll probably find the explanation and examples by sifting through one or two pages of my comment history.