I have a table that has the following str and data
ContainerID, ItemId, DateTime
2, 1, 06/23/2007
3, 2, 06/24/2007
So effectively speaking item 1 is in container 2 which is in container 3.
If I were to retrieve all the containers item 1 is in, what should be the query?
[I need both rows]