Relating tables

[BricioJ]

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 table called "rgs_horas_trabajadas" and the other one is called "Combinar2" both of them have the field "ProyectoId" that i use to make the union, this because i need to get a field i dont have in the table "Combinar2" and is on "rgs_horas_trabajadas". it let me do the connection but when i select the field that i want to add to my principal table the values are multiplied.  

[v-jianboli-msft · Accepted solution]

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.