Tables box

[Anonymous]

Hi,

I need help with creating a table out of data from 3 tables.

I loaded the 3 excel files with the tables needed

but when I create the table box the data I want to be shown does not show.

Basically I have 3 tabloids A,B,C

and I want to show in the table box the following SQL query:

SELECT B.field1,

A.field1,

A.field2,

A.field3,

SUM(B.field2) ,

SUM(B.field3) ,

B.field4,

C.field1,

C.field2,

FROM A, B, C

WHERE 1 = 1

AND A.field1 = B.field5

AND B.field6 = C.field3

GROUP BY B.field1,

A.field1,

A.field2,

A.field3,

B.field4,

C.field1,

C.field2,

HAVING SUM(B..field2) <> 0

is it possible?

[Anonymous]

Hi,

Thank you very much it finally worked correctly.

I eliminated the undeeded fields like you mentioned  and used the script you gave me.

Thank you very much once again.

[#3]

Your welcome.