Aggregate On Two Tables

[Anonymous]

Is it possible to aggregate from two tables ?

For example, something similar to:

Table1:

Load

DocID,

DocType

From Tab1;

Table2:

Load

DocID,

AltID,

Date

From Tab2;

Aggr:

Load

Date,

DocType,

Count(DocID)

Resident Table1, Table2

Group By Date, DocType;

[MayilVahanan · Accepted solution]

Hi

No..

But you can join two tables and then use aggr function. Like this

Table1:

Load

DocID,

DocType

From Tab1;

Left Join(Table1)

Load

DocID,

AltID,

Date

From Tab2;

Load

Date,

DocType,

Count(DocID)

Resident Table1

Group By Date, DocType;

Hope it helps