日期:2014-05-16 浏览次数:20685 次
SELECT * FROM fa_product a LEFT JOIN fa_view_borrow b ON a.id = b.fid LEFT JOIN fa_return c ON b.id = c.bid LIMIT 0 , 50
SELECT a.id id, a.cname cname, a.pname pname, a.cno cno, a.csort csort, a.cxulie cxulie, a.pno pno, a.cperson cperson, a.qty qty, a.cstatus cstatus, a.bd_version bd_version, a.cnote cnote, a.addad4 addad4, a.addip addip, a.addtime addtime, a.lastupdatead4 lastupdatead4, a.lastupdateip lastupdateip, a.lastupdatetime lastupdatetime, a.boardstatus boardstatus, a.firmware_version firmware_version, a.bsp bsp, a.epld epld, a.sad4 sad4, a.sip sip, a.stime stime, a.project project, a.uboot uboot, a.bd_version bd_version, b.place place, b.cname bname FROM fa_product a LEFT JOIN fa_view_borrow b ON a.id = b.fid LEFT JOIN fa_return c ON b.id = c.bid ORDER BY id DESC LIMIT 0 , 50