Join in Server Job

[ankursaxena.2003]

i have a requirement for server job. But if there is a solution with parallel job, then i can make a parallel job also. And below is an example.
It is tough to put down the requirement in words. So i will explain with an example.
For example, Table 1 is the source and table 2 is reference table. For row 5 in table 1 has (2,2,3) combination, then my output should also print for combination (2,2,1) and (2,2,2).

Table 1 (input)
col1 col2 col3
1 1 1 --> row 1
1 1 2 --> row 2
2 1 1 --> row 3
2 1 2 --> row 4
2 2 3 --> row 5

Table 2 (reference)

col1 col2 col3 col4
1 1 1 abc
1 1 2 def
2 1 1 ghi
2 1 2 jkl
2 2 3 mno

Output:

Table
col1 col2 col3 col4
1 1 1 abc
1 1 2 def
2 1 1 ghi
2 1 2 jkl
2 2 1 ghi
2 2 2 jkl
2 2 3 mno

Let me know if you have any questions.....

[rkashyap]

Though it is difficult to understand the complete requirement on basis of the example, I believe that are you trying to insert records based on gaps.
If so, see this post. If not, try to explain the requirement in words.

[chulett]

It is tough to put down the requirement in words.

I would imagine, though, that someone gave you the task and requirements in words did they not?

[priyadarshikunal]

Let me know if you have any questions.....

Yes, on what basis you are expecting these two records in output.
2 2 1 ghi
2 2 2 jkl