I have 3 tables products,colors,assign with this structure:

**products:**

```
product_id | default_color
1          | 1

```

**colors**

```
color_id | color_name
1        | Black
2        | Green
3        | Yellow

```

**assign**

```
product_id | color_id
1          | 1
1          | 2
1          | 3 

```

My query returns only first row from "assign" table, I need to have ALL colors assigned for current product. 

Here is a query I use:

```
SELECT * FROM products p
LEFT JOIN assign a ON p.product_id = '1' 
LEFT JOIN colors c ON a.color_id = c.color_id
WHERE p.product_id = 1

```