[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