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?
