I have a database structure like so
Car
- id
- carname
- image
- category
- status
Parts
- partid
- partname
CarParts
- carpartid
- carid(fk)
- partid(fk)
- amountid(fk)
Category
- id
- categoryname
Amount
- amountid
- amountvalue
and here is my query:
SELECT group_concat(parts.partname) as parts FROM car left join carparts on car.id = carparts.carpartid
left join parts on parts.partid = carparts.carpartid
left join amount on amount.amountid = carparts.amountid where status = 1
group by car.id
but this only display parts and nothing else i want
- carname
- image
- category
- status
Aucun commentaire:
Enregistrer un commentaire