Re: Help with a Left Join
games_files CREATE TABLE `games_files` (
`id` int(11) NOT NULL auto_increment,
`trackname` varchar(100) NOT NULL default '',
`filename` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`screenshot` varchar(60) NOT NULL default '',
`user` varchar(100) NOT NULL default '',
`type` tinyint(4) NOT NULL default '0',
`park` text NOT NULL,
`time` varchar(20) NOT NULL default '',
`original` tinyint(4) NOT NULL default '0',
`totvotes` int(11) NOT NULL default '0',
`totviews` int(11) NOT NULL default '0',
`downloads` int(11) NOT NULL default '0',
`genre` varchar(20) NOT NULL default '',
`contestid` varchar(4) NOT NULL default '0',
`suppfile` varchar(75) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) TYPE=MyISAM
CREATE TABLE `games_ratings` (
`id` int(11) NOT NULL auto_increment,
`trackid` int(11) NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`ip` varchar(20) NOT NULL default '',
`rating` float NOT NULL default '0',
`comments` text NOT NULL,
`timestamp` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) TYPE=MyISAM