sql同时查询一个字段值
来源:互联网 发布:bind源码 内网dns 编辑:程序博客网 时间:2024/06/08 16:24
第一种方式demo:
$sql = "select
g.name,
b.name as b.goods_name
from
`demo`
left join `goods` as g on demo.id=g.goods_id
left join `goods` as b on demo.child_id=b.goods_id";
第二种方式demo:
$sql = "select
c.*,
b.name as goods_name
from (
select
id,
child_id,
g.name
from
`demo`
left join `goods` as g on demo.id=g.goods_id) as c
left join `goods` as b on c.child_id=b.goods_id
";
阅读全文