I need help with a SQL query.
My problem is better explained with some examples.

Say I have my data like this

Doc # | Item #<br>
123 &nbsp;  &nbsp;    EDS100<br>
123 &nbsp;  &nbsp;    DDS200<br>
123 &nbsp;  &nbsp;    DDS500<br>
124 &nbsp;  &nbsp;    LLS220<br>
124 &nbsp;  &nbsp;    LDS254<br>
125 &nbsp;  &nbsp;    FGD450<br>
125 &nbsp;  &nbsp;    LDS552<br>
125 &nbsp;  &nbsp;    DDS200 <br>
125 &nbsp;  &nbsp;    EDD200<br>

I want to return all rows when 1 item number meets the criteria.

Say in this case I want all the rows of the order when one row is equal to DDS200 would give this result:

Doc # | Item #<br>
123 &nbsp;  &nbsp;    EDS100<br>
123 &nbsp;  &nbsp;    <strong>DDS200</strong><br>
123 &nbsp;  &nbsp;    DDS500<br>
125 &nbsp;  &nbsp;    FGD450<br>
125 &nbsp;  &nbsp;    LDS552<br>
125 &nbsp;  &nbsp;    <strong>DDS200</strong> <br>
125 &nbsp;  &nbsp;    EDD200<br>

I'm sure this is trivial, I have tried the following:
*SELECT doc#, item# FROM orders WHERE item# like 'DDS200';* < this only returns the rows that meet the criteria, not all the rows of the order as shown above.

Thanks for your help