select c.*, a.name as areaname from luo_customer as c left join luo_area as a on c.area = a.id
select a.*,b.name as area_name,c.name as industry_name from luo_customer a,luo_area b,luo_industry where a.area = b.id and a.industry = c.id;
select cu.*,ar.name as arname,in.name as inname from luo_customer cu left join luo_area ar on cu.area=ar.id left join luo_industry in on in.id=cu.industry
楼上三位都不是很对啊,这样吧,我把数据库放上来,麻烦你们测试一下!-- phpMyAdmin SQL Dump -- version 4.0.7 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2014-09-23 20:50:40 -- 服务器版本: 5.5.34-log -- PHP 版本: 5.3.27SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;-- -- 数据库: `warzc` ---- ---------------------------------------------------------- -- 表的结构 `luo_area` --CREATE TABLE IF NOT EXISTS `luo_area` ( `id` int(6) NOT NULL AUTO_INCREMENT, `fid` int(6) NOT NULL, `name` varchar(50) NOT NULL, `dateline` datetime NOT NULL, `rank` int(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;-- -- 转存表中的数据 `luo_area` --INSERT INTO `luo_area` (`id`, `fid`, `name`, `dateline`, `rank`) VALUES (1, 0, '文殊片区', '2014-09-21 11:10:32', 0), (2, 0, '锦江区', '2014-09-21 11:10:40', 2), (3, 0, '青羊区', '2014-09-21 11:10:49', 3), (4, 0, '金牛区', '2014-09-21 11:11:00', 4), (5, 0, '成华区', '2014-09-21 11:13:27', 0), (6, 0, '高新区', '2014-09-21 11:11:42', 5), (7, 0, '武侯区', '2014-09-21 11:13:58', 0), (8, 0, '温江区', '2014-09-21 11:14:03', 0), (9, 0, '新都区', '2014-09-21 11:14:10', 0), (10, 0, '龙泉驿区', '2014-09-21 11:14:23', 0), (11, 0, '双流县', '2014-09-21 11:14:31', 0);-- ---------------------------------------------------------- -- 表的结构 `luo_customer` --CREATE TABLE IF NOT EXISTS `luo_customer` ( `id` int(6) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `addr` varchar(100) NOT NULL, `tel` varchar(50) NOT NULL, `mobile` varchar(50) NOT NULL, `qq` varchar(50) NOT NULL, `httpurl` varchar(50) NOT NULL, `fax` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `dateline` datetime NOT NULL, `area` int(5) NOT NULL, `industry` int(5) NOT NULL, `services` varchar(200) NOT NULL, `rank` int(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;-- -- 转存表中的数据 `luo_customer` --INSERT INTO `luo_customer` (`id`, `name`, `addr`, `tel`, `mobile`, `qq`, `httpurl`, `fax`, `email`, `dateline`, `area`, `industry`, `services`, `rank`) VALUES (27, '成都', '成都', '123456', '123456', '100', '', '', '', '2014-09-22 20:41:21', 1, 2, '1,,,', 0), (29, 'afas', 'asfa', 'asfa', 'fafsa', '200', '', '', '', '2014-09-23 00:24:01', 10, 2, '1,2014-9-18,,123456', 0);-- ---------------------------------------------------------- -- 表的结构 `luo_industry` --CREATE TABLE IF NOT EXISTS `luo_industry` ( `id` int(6) NOT NULL AUTO_INCREMENT, `fid` int(6) NOT NULL, `name` varchar(50) NOT NULL, `dateline` datetime NOT NULL, `rank` int(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;-- -- 转存表中的数据 `luo_industry` --INSERT INTO `luo_industry` (`id`, `fid`, `name`, `dateline`, `rank`) VALUES (1, 0, '公众客户', '2014-09-21 11:09:21', 0), (2, 0, '商业客户', '2014-09-21 11:15:55', 0);-- ---------------------------------------------------------- -- 表的结构 `luo_manager` --CREATE TABLE IF NOT EXISTS `luo_manager` ( `id` int(6) NOT NULL AUTO_INCREMENT, `username` varchar(20) NOT NULL, `password` varchar(32) NOT NULL, `usermenu` text NOT NULL, `loginip` varchar(25) NOT NULL, `logintime` varchar(10) NOT NULL, `logincount` int(5) NOT NULL, `supermanager` int(2) NOT NULL, `addtime` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;-- -- 转存表中的数据 `luo_manager` --INSERT INTO `luo_manager` (`id`, `username`, `password`, `usermenu`, `loginip`, `logintime`, `logincount`, `supermanager`, `addtime`) VALUES (1, 'dxgg123', 'd44c673a5c3e96be5569d05bc41e7ad1', '', '222.210.198.215', '2014-09-22', 0, 0, '2009-06-08 10:38:08');-- ---------------------------------------------------------- -- 表的结构 `luo_services` --CREATE TABLE IF NOT EXISTS `luo_services` ( `id` int(6) NOT NULL AUTO_INCREMENT, `fid` int(6) NOT NULL, `name` varchar(50) NOT NULL, `dateline` datetime NOT NULL, `rank` int(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;-- -- 转存表中的数据 `luo_services` --INSERT INTO `luo_services` (`id`, `fid`, `name`, `dateline`, `rank`) VALUES (1, 0, '', '2014-09-21 11:08:12', 0), (2, 0, '', '2014-09-21 11:18:14', 0), (3, 0, '', '2014-09-21 11:18:21', 0), (4, 0, '', '2014-09-21 11:18:26', 0), (5, 0, '', '2014-09-21 11:18:29', 0), (6, 0, '', '2014-09-21 11:18:33', 0), (7, 0, '', '2014-09-21 11:18:37', 0), (8, 0, '', '2014-09-21 11:18:58', 0), (9, 0, '', '2014-09-21 11:19:20', 0), (10, 0, '', '2014-09-21 11:19:39', 0), (11, 0, '', '2014-09-21 11:20:16', 0), (13, 0, '', '2014-09-21 11:42:26', 0), (14, 0, '', '2014-09-21 11:42:38', 0), (15, 0, '', '2014-09-21 11:42:46', 0), (16, 0, '', '2014-09-21 11:42:53', 0), (17, 0, '', '2014-09-21 12:00:37', 0), (18, 0, '', '2014-09-21 12:00:46', 0), (19, 0, '', '2014-09-21 12:00:54', 0);/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
select a.*,b.name as area_name,c.name as industry_name from luo_customer a,luo_area b,luo_industry where a.area = b.id and a.industry = c.id;
select cu.*,ar.name as arname,in.name as inname from luo_customer cu
left join luo_area ar on cu.area=ar.id
left join luo_industry in on in.id=cu.industry
-- version 4.0.7
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2014-09-23 20:50:40
-- 服务器版本: 5.5.34-log
-- PHP 版本: 5.3.27SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;--
-- 数据库: `warzc`
---- ----------------------------------------------------------
-- 表的结构 `luo_area`
--CREATE TABLE IF NOT EXISTS `luo_area` (
`id` int(6) NOT NULL AUTO_INCREMENT,
`fid` int(6) NOT NULL,
`name` varchar(50) NOT NULL,
`dateline` datetime NOT NULL,
`rank` int(6) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;--
-- 转存表中的数据 `luo_area`
--INSERT INTO `luo_area` (`id`, `fid`, `name`, `dateline`, `rank`) VALUES
(1, 0, '文殊片区', '2014-09-21 11:10:32', 0),
(2, 0, '锦江区', '2014-09-21 11:10:40', 2),
(3, 0, '青羊区', '2014-09-21 11:10:49', 3),
(4, 0, '金牛区', '2014-09-21 11:11:00', 4),
(5, 0, '成华区', '2014-09-21 11:13:27', 0),
(6, 0, '高新区', '2014-09-21 11:11:42', 5),
(7, 0, '武侯区', '2014-09-21 11:13:58', 0),
(8, 0, '温江区', '2014-09-21 11:14:03', 0),
(9, 0, '新都区', '2014-09-21 11:14:10', 0),
(10, 0, '龙泉驿区', '2014-09-21 11:14:23', 0),
(11, 0, '双流县', '2014-09-21 11:14:31', 0);-- ----------------------------------------------------------
-- 表的结构 `luo_customer`
--CREATE TABLE IF NOT EXISTS `luo_customer` (
`id` int(6) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`addr` varchar(100) NOT NULL,
`tel` varchar(50) NOT NULL,
`mobile` varchar(50) NOT NULL,
`qq` varchar(50) NOT NULL,
`httpurl` varchar(50) NOT NULL,
`fax` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`dateline` datetime NOT NULL,
`area` int(5) NOT NULL,
`industry` int(5) NOT NULL,
`services` varchar(200) NOT NULL,
`rank` int(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;--
-- 转存表中的数据 `luo_customer`
--INSERT INTO `luo_customer` (`id`, `name`, `addr`, `tel`, `mobile`, `qq`, `httpurl`, `fax`, `email`, `dateline`, `area`, `industry`, `services`, `rank`) VALUES
(27, '成都', '成都', '123456', '123456', '100', '', '', '', '2014-09-22 20:41:21', 1, 2, '1,,,', 0),
(29, 'afas', 'asfa', 'asfa', 'fafsa', '200', '', '', '', '2014-09-23 00:24:01', 10, 2, '1,2014-9-18,,123456', 0);-- ----------------------------------------------------------
-- 表的结构 `luo_industry`
--CREATE TABLE IF NOT EXISTS `luo_industry` (
`id` int(6) NOT NULL AUTO_INCREMENT,
`fid` int(6) NOT NULL,
`name` varchar(50) NOT NULL,
`dateline` datetime NOT NULL,
`rank` int(6) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;--
-- 转存表中的数据 `luo_industry`
--INSERT INTO `luo_industry` (`id`, `fid`, `name`, `dateline`, `rank`) VALUES
(1, 0, '公众客户', '2014-09-21 11:09:21', 0),
(2, 0, '商业客户', '2014-09-21 11:15:55', 0);-- ----------------------------------------------------------
-- 表的结构 `luo_manager`
--CREATE TABLE IF NOT EXISTS `luo_manager` (
`id` int(6) NOT NULL AUTO_INCREMENT,
`username` varchar(20) NOT NULL,
`password` varchar(32) NOT NULL,
`usermenu` text NOT NULL,
`loginip` varchar(25) NOT NULL,
`logintime` varchar(10) NOT NULL,
`logincount` int(5) NOT NULL,
`supermanager` int(2) NOT NULL,
`addtime` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;--
-- 转存表中的数据 `luo_manager`
--INSERT INTO `luo_manager` (`id`, `username`, `password`, `usermenu`, `loginip`, `logintime`, `logincount`, `supermanager`, `addtime`) VALUES
(1, 'dxgg123', 'd44c673a5c3e96be5569d05bc41e7ad1', '', '222.210.198.215', '2014-09-22', 0, 0, '2009-06-08 10:38:08');-- ----------------------------------------------------------
-- 表的结构 `luo_services`
--CREATE TABLE IF NOT EXISTS `luo_services` (
`id` int(6) NOT NULL AUTO_INCREMENT,
`fid` int(6) NOT NULL,
`name` varchar(50) NOT NULL,
`dateline` datetime NOT NULL,
`rank` int(6) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;--
-- 转存表中的数据 `luo_services`
--INSERT INTO `luo_services` (`id`, `fid`, `name`, `dateline`, `rank`) VALUES
(1, 0, '', '2014-09-21 11:08:12', 0),
(2, 0, '', '2014-09-21 11:18:14', 0),
(3, 0, '', '2014-09-21 11:18:21', 0),
(4, 0, '', '2014-09-21 11:18:26', 0),
(5, 0, '', '2014-09-21 11:18:29', 0),
(6, 0, '', '2014-09-21 11:18:33', 0),
(7, 0, '', '2014-09-21 11:18:37', 0),
(8, 0, '', '2014-09-21 11:18:58', 0),
(9, 0, '', '2014-09-21 11:19:20', 0),
(10, 0, '', '2014-09-21 11:19:39', 0),
(11, 0, '', '2014-09-21 11:20:16', 0),
(13, 0, '', '2014-09-21 11:42:26', 0),
(14, 0, '', '2014-09-21 11:42:38', 0),
(15, 0, '', '2014-09-21 11:42:46', 0),
(16, 0, '', '2014-09-21 11:42:53', 0),
(17, 0, '', '2014-09-21 12:00:37', 0),
(18, 0, '', '2014-09-21 12:00:46', 0),
(19, 0, '', '2014-09-21 12:00:54', 0);/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;