lStrsql = "select base.id,more.pid,zhiwu.pid from base, inner ,join ,more WHERE base.id=more.pid "
这个是什么 inner join zhiwu on more.pid=zhiwu.pid "
这个是什么 inner join zhiwu on more.pid=zhiwu.pid "
因为你的主表是 Base ,inner join zhiwu 时是指 Base 连 zhiwu你可以那么写lStrsql = "select base.id,more.pid,zhiwu.pid from base ,more,
zhiwu Where base.id=more.pid and more.pid=zhiwu.pid "
lStrsql = "select base.id,more.pid,zhiwu.pid from base inner join more on base.id=more.pid inner join zhiwu on base.id=zhiwu.pid "
不就行了。但是还是不好用啊
lStrsql = "select bs.id,mr.pid,zw.pid from base bs inner join more mr on bs.id=mr.pid inner join zhiwu zw on bs.id=zw.pid "