The table structures are as follows

CREATE TABLE [CustomerMapping] (

[PKid] [int] IDENTITY (1, 1) NOT NULL ,

[ClientNo] [int] NULL ,

[Customer] [int] NULL ,

) ON [PRIMARY]

GO

CREATE TABLE [CustomerMapping_Stage] (

[ClientNo] [int] NULL...