Question

thinkphp 多表查询出错了。

$WithdrawRecord=D('withdraw_record');
$WithdrawRecords=$WithdrawRecord->table('withdraw_record w','user u')
->where('w.user_id=u.id')
->field('u.nickname,w.update_time')->select();

Answer 1

$WithdrawRecord = D('WithdrawRecord');
$WithdrawRecords = $WithdrawRecord->table('withdraw_record w,user u')
->where('w.user_id=u.id')
->field('u.nickname,w.update_time')->select();
注意table方法内的参数
也可以
$WithdrawRecords = $WithdrawRecord->table('__WITHDRAW_RECORD__ w,__USER__ u')
->where('w.user_id=u.id')
->field('u.nickname,w.update_time')->select();
此处会把__WITHDRAW_RECORD__与__USER__替换为真实的表名