Cross join on a group based on the condition in SQL Server

Viewed 1724

I have Item and Exam tables -

enter image description here

My desire result -

enter image description here

I tried a lot but I am unable to join Exam table to Item table based on Code group.

Is it possible to cross join or any other join for these two tables to get the desire result?

3 Answers
Related