subquery pull - All lines

Question

I am pulling information from a table with multiple lines that all corrorpond to one ticket. If anywhere on the ticket I see a charge for MIlk I want to see all lines associated with that ticket#. I tried to write a subquery but that has not worked for me. Any ideas??

Example:

Item Cost

1. Yams 1.0
2. Beans 2.0
3. Milk 5.0
4. Yams 1.0
5. Beans 2.0
6. Candy 1.0
7. Beans 2.0
8. Yams 1.0
9. Beans 2.0
10. Milk 5.0
11. Beans 2.0
12. Milk 5.0

Answer 1

Something like

select *
from Items
where TicketId in
  (
    select distinct TicketId
    from Items
    where ItemName = 'Milk'
  )

?