Forum Discussion

BricioJ's avatar
BricioJ
Frequent Visitor
3 years ago
Solved

Relating tables

Im having a problem, I'm creating a table made from the union of several tables, i have in total 69 datafields but when i made an specific union between 2 tables the values are multiplied. i have a t...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi BricioJ ,

     

    If you want to get a field you dont have in the table "Combinar2" and is on "rgs_horas_trabajadas" , you may need to use EXCEPT function instead of union.

    Except function will returns the rows of the first table in the expression which do not appear in the second table.

    Union function just reates a union (join) table from a pair of tables.

     

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi BricioJ ,

 

If you want to get a field you dont have in the table "Combinar2" and is on "rgs_horas_trabajadas" , you may need to use EXCEPT function instead of union.

Except function will returns the rows of the first table in the expression which do not appear in the second table.

Union function just reates a union (join) table from a pair of tables.

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.