DATE Problem

[#1]

Hi Experts,

i have data in two tables,

Table1

Year

Month

Table2

Year

Month

Sales

But In Table1 having Years & Table2 having Years are different years.

But i want Both information There is a Synthetic table firm in between them How i can Join this two.

to get both tables data.

Please help me

[aveeeeeee7en]

Table1

Year

Month

'Table1'  AS Selection

Concatenate

Table2

Year

Month

Sales

'Table2'  AS Selection

You will get information from both the tables. Also synthetic table will not form in between them.

A new field will be created 'Selection', it will tell you the year and data is coming from which table.

[#3]

can u provide example qvw or data so we can understand clearly