select A.id 产品ID,A.name 产品名称,(select info from B where A.id=B.listid and b.parid=1) 产品型号, (select info from B where A.id=B.listid and b.parid=2) 产品品牌,(select info from B where A.id=B.listid and b.parid=3) 产品价格 from A
select A.id 产品ID,A.name 产品名称,(select info from B where A.id=B.listid and b.parid=1) 产品型号, (select info from B where A.id=B.listid and b.parid=2) 产品品牌,(select info from B where A.id=B.listid and b.parid=3) 产品价格 from A
select A.id 产品ID,A.name 产品名称,(select info from B where A.id=B.listid and b.parid=1) 产品型号,
(select info from B where A.id=B.listid and b.parid=2) 产品品牌,(select info from B where A.id=B.listid and b.parid=3) 产品价格 from A
(select info from B where A.id=B.listid and b.parid=2) 产品品牌,(select info from B where A.id=B.listid and b.parid=3) 产品价格 from A