php - 这句sql语句怎么用TP3.1的语法组装起来呢？

Question

SELECT create_date,content,creator,belong_to_user,gs_log.customer_code,follow_up_way FROM gs_log 
LEFT JOIN gs_customer ON (gs_log.customer_code   =  gs_customer.customer_code) WHERE gs_customer.customer_code !=''

请问这句sql语句怎么用thinkphp 3.1的语法组装起来呢？

Answer 1

$data = $User -> alias('a')

                  -> where()
                  -> join('LEFT JOIN gamer_user_details b ON a.id = b.userid')
                  -> getField('a.id,a.username,b.userpic');
                  
                  不帮你写那么详细了 格式是这样的

Answer 2

自己写好了

  $log_join = "left join __CUSTOMER__ b  on a.customer_code = b.customer_code";
  $log_data = M('log')->alias('a')->where("b.customer_code != ''")->join($log_join)->field("log_id,create_date,content,creator,belong_to_user,a.customer_code,follow_up_way")->select();