Joining tables

[rajiv436]

table 1 have input as below

code;

1

2

3

table 2 have input as below

item_no;

100

101

102

required output as

code item_no;

1     100
1     101
1     102
2     100
2     101
2     102
3     100
3     101
3     102

Any help will be really appreciated. Thank you

[LinusH · Accepted solution]

Cartesian SQL join will do the job.

[rajiv436]

Just got it . Thank you