Here's what I'm trying to accomplish...

LEFT JOIN [dbo].[Payment] ON ([dbo].[Commitment].[CommitmentID]=[dbo].[Payment].[CommitmentID] AND [dbo].[Payment].[DeletedLoginID] IS NULL

I'm using a TypedList, and I'm not sure if llbl supports a multiple criteria join. Does anyone know how to do this?

Thank you, Sonny.

the Relation.CustomerFilter property. it would look something like this:

IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.Add([new relation);
bucket.Relations[0].CustomerFilter = (PaymentFields.DeletedLoginID == DbNull.Value;

In your typed list the RelationPredicateBucket is already built, so all you have to do add the CustomerFilter line. This can be done in the User Code Region of the TypedList when building the relationships, or use a partial class and override the OnRelationsBuilt.