I would like to query related data from an additional table, where I am able to get the lowest associated value...

**Example of two tables**

```
products
id          name          description
0           product_1     short description of 1
1           product_2     short description of 2

prices
id          product_id          option        price       personal
0           1                   3             10.00       1
1           0                   2             15.00       1
2           1                   3             5.00        0
3           1                   3             8.00        0
4           0                   2             7.00        1

```

**Output needed**

```
id          name          description       price     option
0           product_1     short ...         7.00      2
1           product_2     short ...         10.00     3

```

The query I am basically attempting to make is one which gets all associated fields, gets the associated data from prices where personal = 1 and has the lowest price.

**Current query** (getting lowest price but not associated option)

```
SELECT products.*, prices.option, 
   (SELECT ROUND( MIN( price ), 2) FROM prices WHERE product_id = products.id AND personal = 1) AS price 
FROM products 
ORDER BY price_low ASC

```