Here's some sample data

CREATE TABLE dbo.Subscriptions (

SubscriptionId bigint identity(1,1) NOT NULL,

CustomerId varchar(12) NOT NULL,

...

In the scenario described it wouldn't matter which payment was meant for each subscription Id because the assumption is that the subscription doesn't capture any information besides the client id,...

Thank you for the reply!

In my haste to post the question I entered one row too many for subscriptions.

The scenario is that the two tables are populated with information coming...