match two tables

[#1]

Hi please help me,

i have two tables

1.  Date/KST/value

2. KST/value

the Problem is that in table 2 are only value from exact one KST (1747)

and in table 1 this KST exist with the sum of table 2

my Problem is to create a Pivot in which the rows of the table 2 are shown in teh same column like the other values from table 1 kst

hope u can help me

[#2]

ok can u say how i can load the table 1 without the KST 1747 ?

[puttemans · Accepted solution]

After the load statement, you add a where-clause :

FROM .....

WHERE KST <> 1747;

[#4]

thanx a lot