Displaying 1 result from an estimated 1 matches for "arealead".
Did you mean:
arealeader
2010 May 01
1
I need some help joining data from 3 MySQL tables, please
...ng user's name &
email from another table.
Table structures to follow:
CREATE TABLE `jos_mls_teams` (
`id` int(11) NOT NULL auto_increment,
`userid` int(5) NOT NULL,
`memberid` int(11) NOT NULL,
`name` varchar(255) NOT NULL default '',
`email` text,
`area` text,
`arealeader` varchar(150) NOT NULL,
`founded` text,
`herder` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
CREATE TABLE IF NOT EXISTS `jos_users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`us...