I'm trying to combine two tables as I mentioned below, but it doesn't work...
"select fixtures_apps.away AS player, count(fixtures_scorers.player) goals from fixtures_scorers,fixtures_apps GROUP BY player ORDER BY goals desc "
Why not?
Any ideas?
what does SQL give you for error? 'cause i retry it here with my own database and it's working so by now I really don't know why yours not working...
Jacinthe
It gives me this:
http://www.spursweb.com/season0102/scorers2.phtml
That, obviously, is not the correct number of goals for each player. I have no idea where those numbers come from.
i got it, you have to link your two table with a where clause like this :
WHERE table1.key1 = table2.key2
as key1 and key2 are the same field but in different table.
the way we are doing it right now, we don't join the tables so...
