Try this
with courseIdTemp (Courceno , PaperID) as
(
SELECT course.Courseno,ids.PaperID
FROM course CROSS JOIN
ids WHERE course.Courseno=ids.Courseno
)
Select * from courseIDTemp
or
SELECT course.Courseno,ids.PaperID
into CourceIDMix
FROM course CROSS JOIN
ids WHERE course.Courseno=ids.Courseno
select * from CourceIDMix