An example of While/Select statements to find InventSerials, when Works Order is known. Here I also will use a chance to note the ListEnumerator. No Joins are used in this example.
An example of achieving same result using Queries.
public class YourClass
InventTrans inventTrans ...
There are comments. Feel free to leave your comment.