select * from (select b.*,c.name bookcaseName,
p.pubname publishing,t.typename from tb_bookinfo b
left join tb_bookcase c on b.bookcase=c.id join
tb_publishing p on b.ISBN=p.ISBN join tb_booktype t
on b.typeid=t.id where b.del=0) book
where book.author like '%dgdgf%';新表book 中的typeid字段和原表 bookInfo中的typeid字段的类型一样嘛?
p.pubname publishing,t.typename from tb_bookinfo b
left join tb_bookcase c on b.bookcase=c.id join
tb_publishing p on b.ISBN=p.ISBN join tb_booktype t
on b.typeid=t.id where b.del=0) book
where book.author like '%dgdgf%';新表book 中的typeid字段和原表 bookInfo中的typeid字段的类型一样嘛?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货