Tables aggregation

[#1]

Hi All,

We have 4 tables with a common field for all (CName) and some other fields with difrent name but with the same content(some of them)

Please help me to find out if CName is present or not in the other tables like bellow and how many.

Table 1	Table 2	Table 3	Table 4
CName	no	no	no
	yes	no	no
	yes	yes	no
	yes	no	yes
Table 2	Table 1	Table 3	Table 4
Cname	no	yes	yes
	no	no	no

Table1:
LOAD CName,
...
...
...

FROM ..."..." WHERE (...);
store Table1 into Table1.qvd (QVD);

Table2:
LOAD CName,
     ...............
     ...............
     ...............
    
FROM
["Path..."Table2.qvd]
(qvd);

Table3:
LOAD CName,
     ...............
     ...............
     ...............

FROM
["Path..."Table3.qvd]
(qvd);

Table4:
LOAD CName,
      ...............
      ...............
      ...............

FROM
["Path..."Table4.qvd]
(qvd);