php - sql连接需要进一步的帮助

Question

我被困在一个查询中，我想在其中显示来自不同表及其桥接表的数据。
这些表是:

bridge (bid,planid,fbridgeid)
fbridge (fbridgeid,featureid,valueid)
features (featureid,fname)
value (valueid,value)
plans (planid,name,price,discount)

以下是我目前的查询:

SELECT 
(NAME AS pname, price AS prize,
 discount AS ds, fname AS feature, VALUE AS vlue 
FROM plans  )

我想从数据库中获取所有的列，但是按照计划

like planid 1 ->> contains ->> feature id 1,2,3 and valueid 1,3,5 etc )

Answer 1

Join 将是:

SELECT pl.name AS pname, pl.price AS prize , pl.discount AS ds , fe.fname AS feature, va.VALUE AS vlue
FROM plans pl
JOIN bridge br ON br.planid = pl.planid
JOIN fbridge fb ON fb.fbridgeid = br.fbridgeid
JOIN features fe ON fe.featureid = fb.featureid
JOIN value va ON va.valueid = fb.valueid
WHERE pl.plainid = 1