thinkphp如何做表的内连接

Question

thinkphp如何做表的内连接

Answer 1

M("product p")->join('inner join outstock o on p.id=o.p_id')->select();
或者
M('product p,outstock o ')->where(' p.id=o.p_id')->select();