table多表查询加入查询条件后，查不出记录，生成的sql语句有问题
生成的错误
SELECT `goods`.`goods_name`,`images`.`image_url`,`goods`.`goods_id` FROM `tp_goods` `goods`,`tp_goods_images` `images` WHERE `goods`.`goods_id` = 'images.goods_id'
正确的sql
SELECT `goods`.`goods_name`,`images`.`image_url`,`goods`.`goods_id` FROM `tp_goods` `goods`,`tp_goods_images` `images` WHERE `goods`.`goods_id` = 'images.goods_id'

微信图片_20190215121520.png ( 20.61 KB 下载：8 次 )