[thelist] Re: mySQL query [solved]
Tom Dell'Aringa
pixelmech at yahoo.com
Fri Jun 11 10:46:37 CDT 2004
--- Tab Alleman <Tab.Alleman at MetroGuide.com> wrote:
> Not that this will necessarily solve your problem, but you might
> want to alias the two team names in your select list..
>
> > SELECT
> > games.gamesdate, games.a1, games.a2, games.a3, games.b1,
> games.b2,
> > games.b3,
> > games.teamAID, games.teamBID, a.name AS NameTeamA, b.name AS
> NameTeamB
Yep, that was the problem, and rudy pointed out the same thing to me
as well off-list (I misspoke when I said he is back on the list, he
isn't). Thanks!
Tom
=====
http://www.Pixelmech.com/ - read my latest blog posting!
http://www.crossandthrone.com/ - Eternal Life
John 3:16
More information about the thelist
mailing list