Thanks all but I think I've got it.

For the matched key it's something like..

INSERT INTO dbo.LSR_Pass

(

K1,

K2,

K3,

K4,

K5

)

SELECT

B.K1,

B.K2,

B.K3,

B.K4,

MAX(A.K5) + 1

FROM dbo.LSR_Prepare B JOIN dbo.LSR_Pass A...

That's very interesting... (and it works)

Thanks for your reply,

Neal