I have a table that contains shipping and receiving info for parts. The first record is the shipping record. Subsequent records are receipt records:

This part has been shipped from location 1, received at location 152, the moved to 
locations 565 and 202

RecId PartNo	LocationId	SerialNo        Qty		Date	                Sequence
-----------------------------------------------------------------------------------
5228	 17908	1		HUB5K043NC	1		NULL			1
5229	 17908	152		HUB5K043NC	1		2009-01-22 00:00:00.000	2
5230	 17908	565		HUB5K043NC	1		2009-02-02 00:00:00.000	3
5231	 17908	202		HUB5K043NC	1		2009-02-02 00:00:00.000	4



This part has been shipped from location 1, but not yet received

RecId PartNo	LocationId	SerialNo	 Qty		Date	                       Sequence
-----------------------------------------------------------------------------------
5953	16577	1		3BV0GW03	1		2009-04-01 00:00:00.000	1

The combination of PartNo and SerialNo make a record unique. How do I pull only records that have not yet been received?