Re: Query - multiple joins won't return any records
No need to reinvent this wheel ...
teams( teamID, ... )
divisions( divID, teamID, ... )
games( gameID, team1id, team1score, team2id, team2score, ...)
I see no need for a cumbersome relations table. If you want to express relationships in the DDL, do it with foreign keys.
And use InnoDB, MyISAM is old and inadequate.
Subject
Written By
Posted
February 13, 2015 09:32PM
Re: Query - multiple joins won't return any records
February 14, 2015 10:21AM
February 14, 2015 10:57AM
February 14, 2015 03:03PM
February 15, 2015 01:40AM
February 15, 2015 09:59AM
February 15, 2015 01:40PM
February 15, 2015 02:33PM
February 15, 2015 02:54PM
February 15, 2015 03:09PM
February 15, 2015 07:59PM
February 19, 2015 03:06PM
February 19, 2015 04:17PM
February 21, 2015 07:01PM
February 14, 2015 11:39PM