比如有3个表:
tableA : userid name sex tel addr
tableB : userid mname fname course
tableC : userid zuoye fenshu level搜索条件:name=xiaom, mname=mm , fenshu=60
如何做呢?
tableA : userid name sex tel addr
tableB : userid mname fname course
tableC : userid zuoye fenshu level搜索条件:name=xiaom, mname=mm , fenshu=60
如何做呢?
$sql = " select a.*,b.*,c.* from tableA as a
inner join tableB as b on a.userid=b.userid
inner join tableC as c on a.userid=c.userid and c.fenshu=60 ";