Can I do this with just SQL?
- by Josh
At the moment I have two tables, products and options.
Products contains
id
title
description
Options contains
id
product_id
sku
title
Sample data may be:
Products
id: 1
title: 'test'
description: 'my description'
Options
id: 1
product_id: 1
sku: 1001
title: 'red'
id: 2
product_id: 1
sku: 1002
title: 'blue'
I need to display each…