Question

这条sql语句用tinkphp怎么做连贯操作

select a.name a.author b.text1 b.source from pr_essay a,pr_content b
where a.id=b.eid and a.id=2;

Answer 1

$model->filed（“MAX(ap.step) max_step, yt.yacht_name, tk.*“）->alias("tk")->join("LEFT JOIN pt_approve as ap on ap.request_id = tk.toid LEFT JOIN pt_yacht as yt on yt.yid = tk.yid")->where("ap.type = 'TakeOn' AND ap.`status` = 1")->group(ap.request_id HAVING MAX(ap.step) > 0)->select();

你语句没问题的话，大致就是这样。如果有错，就打印上一条语句。$model->getLastSql();