Create one table from 2 different tables

[Anonymous]

Hi

I have 2 tables :

QV_RET_OVED_VW with the columns :

     COMMERCIAL_NUM,

     COMMERCIAL,

     GROUPE_OVED

QV_RET_FAMILLES_VW with the columns :

     COMMERCIAL,

     FAMILLE_NUM

     YEARMONTH

I want to create a table QV_RET_GROUPE_OVED with the columns :

     GROUPE_OVED

     COUNT(FAMILLE_NUM)

That represents the count of FAMILLE_NUM for each GROUP_OVED and by YEARMONTH

I have tried with the expression 'Resident' but it doesn't work

Thank you for your help

Regards

[Anonymous]

Hi

If I have 3 tables to link, how can I do ?

[Gysbert_Wassenaar]

No idea. You'll have to show the data model and explain what the result should be. An example with some data would help.

[Anonymous]

I addition to the tables QV_RET_OVED_VW and QV_RET_FAMILLES_VW,

I want to link the table QV_RET_FACTURATION wich colums are :

COMMERCIAL

MARGE

and to have in the final table

GROUPE_OVED (from the table QV_RET_OVED_VW)

count(FAMILLE_NUM) as Count (from the table QV_RET_FAMILLES_VW)

sum (MARGE) as SUM_MARGE (from the table QV_RET_FACTURATION )

group by GROUPE_OVED;

Thanks a lot