这个是昨天遇到的事了,是写简历搜索器的时候遇到的,查阅了很多的资料,这里记录一下一些SELECT联合查询中遇到的一些问题并附带解决办法
首先上例子:
$sql="";
$sql.=" SELECT ";
$sql.=" ".T_."person_info.personid, ";
$sql.=" ".T_."person_info.personname, ";
$sql.=" ".T_."person_info.sex, ";
$sql.=" year(".T_."person_info.birthday) AS age, ";
$sql.=" MAX(".T_."person_edu.education) AS xueli, ";
$sql.=" ".T_."person_edu.school, ";
$sql.=" GROUP_CONCAT(".T_."person_edu.`subject`), ";
$sql.=" ".T_."person_info.shi1 ";
$sql.=" FROM ";
$sql.=" ".T_."person_info ";
$sql.=" LEFT JOIN ".T_."person_edu ON ".T_."person_info.personid = ".T_."person_edu.personid ";
$sql.=" WHERE 1=1 ";
$sql.=" AND ".T_.&