I have one order order have a lot of articles and 2 articles have same color i can get color\_no from color where order\_id is ican put when i can below query execute thie error shown Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. i know that duplicate record there but i need this data //select all color which order\_id is given in below query if duplicate no problem show the colors:

```
select color_no from color
where color_id=(select trans_id from transaction_order
where order_id=(select order_id from master_order where program_no='13-065454'))

```