Unknown column 'ts.sp_id' in 'on clause' SELECT t.*,ts.weibo_id FROM bind_t AS t LEFT JOIN bbs_ts AS ts ON t.id = ts.sp_id WHERE ts.id = 2429