InnerJoinOnRowNumber.sql

SELECT r.[RegistrationId], dc.[DigitalCodeId] 
FROM 
  (
    SELECT [RegistrationId], row_number() OVER (ORDER BY [RegistrationId]) AS row_num
    FROM [dbo].[Registration] 
    WHERE [JobNumber] = 12897 AND [OrderNumber] = 5405
  ) r
JOIN
    (
      SELECT [DigitalCodeId], row_number() OVER (ORDER BY [DigitalCodeId]) as row_num
      FROM [dbo].[DigitalCodes] 
      WHERE [CardNumber] NOT IN 
		  (
        SELECT [CardNumber] FROM [dbo].[Fulfillment]
      )
    ) dc 
ON  r.row_num = dc.row_num
ORDER BY r.[RegistrationId], dc.[DigitalCodeId];