Hi everyone: I have this select

[MichHart]

Hi everyone:

I have this select statement that is joining 3 tables, but it is telling me I have a syntax error in the join?

Anyone pick out what is wrong with this??

Set rs = db.Execute("SELECT Leagues.[Index], Leagues.[ShortName] FROM Leagues INNER JOIN (Leagues INNER JOIN [Teams] ON [Teams].League = Leagues.Index) ON Players.[CurTeam] = Teams.Index GROUP BY ShortName&quot

Thanks for any help

MichHart " Never regret yesterday because it cannot be changed;
Instead make sure today does not become a regret of tomorrow."

 

[jebry]

Hi!

You use Leagues twice and Players not at all. I think you want Players instead of the first use of Leagues. Also, you will need to add Index to your Group By statement.

hth
Jeff Bridgham
bridgham@purdue.edu