How to Create Duplicates

[bimanbeginner]

Hi There

I have two tables and require the output of the table 3

How can I join this? I have tried outer join doesn't seem to work...

Table 1
Field 1	Field2
Value1	Field2Value1
Value2	Field2Value2
Value3	Field2Value3

Table2

Field2

Field2Value1

Field2Value2

Field2Value3

Field2Value4

Field2Value5

Field2Value6

Required Output
Table 3
Field 1	Field2
Value1	Field2Value1
Value1	Field2Value2
Value1	Field2Value3
Value1	Field2Value4
Value1	Field2Value5
Value1	Field2Value6
Value2	Field2Value1
Value2	Field2Value2
Value2	Field2Value3
Value2	Field2Value4
Value2	Field2Value5
Value2	Field2Value6
Value3	Field2Value1
Value3	Field2Value2
Value3	Field2Value3
Value3	Field2Value4
Value3	Field2Value5
Value3	Field2Value6
Value4	Field2Value1
Value4	Field2Value2
Value4	Field2Value3
Value4	Field2Value4
Value4	Field2Value5
Value4	Field2Value6
Value5	Field2Value1
Value5	Field2Value2
Value5	Field2Value3
Value5	Field2Value4
Value5	Field2Value5
Value5	Field2Value6
Value6	Field2Value1
Value6	Field2Value2
Value6	Field2Value3
Value6	Field2Value4
Value6	Field2Value5
Value6	Field2Value6

[niclaz79 · Accepted solution]

Hi,

Try this:

Table1:

LOAD

    Field1

From location;

outer join (Table1)

LOAD

    Field2

From location2;

By skipping the Field2 on the first table you don't have any keys that match, which will cause the expected result.