Pages

SQL Puzzle1


Very Recently i faced one Problem, struggled a lot to Find Solution, but didn't find that solution yet. So trying to share that Problem with you all.
Consider there are two tables. Table 1 and Table 2.

Table 1 Contain Following Details


Question_IdQuestion
1Question1
2Question2
3Question3
4Question4

Table 2 Contain Following Details

Question_IdOption_IdOptions
111Q1Option1
112Q1Option2
113Q1Option3
114Q1Option4
221Q2Option1
222Q2Option2
223Q2Option3
224Q2Option4
331Q3Option1
332Q3Option2
333Q3Option3
334Q3Option4
335Q3Option5
336Q3Option6
441Q4Option1
442Q4Option2
443Q4Option3
444Q4Option4
445Q4Option5

Now we have to write a Query that should return a Table in a Below Stated format.

IDQuestionOption
1Question1
11Q1Option1
12Q1Option2
13Q1Option3
14Q1Option4
2Question2
21Q2Option1
22Q2Option2
23Q2Option3
24Q2Option4
3Question3
31Q3Option1
32Q3Option2
33Q3Option3
34Q3Option4
35Q3Option5
36Q3Option6
4Question4
41Q4Option1
42Q4Option2
43Q4Option3
44Q4Option4
45Q4Option5

Condition:
Never use UNION and LOOP


Thank you

0 comments:

Post a Comment