Query is duplicating values

[epardo87]

Hello All,

I have the following query which is pulled from another query and tables, it is duplicating some rows and I can't figure out why, the original Query has 60 records and this one has 3960 records. I want the same 60 but with the additional columns.



I'd appreciate your help a lot, thanks!

this is the SQL:


SELECT [Qry-CertLast].Estación, [Qry-CertLast].MaxOfFecha, [Qry-CertLast].Operador, [tbl-1-2-Estaciones].DíasCert, IIf([MaxOfFecha]+[DíasCert]>Now(),"Vigente","Vencída") AS Status, [MaxOfFecha]+[DíasCert] AS Due
FROM [Qry-CertLast], [tbl-1-2-Estaciones];

[pbaldy]

Without a join, you the Cartesian product of the 2 sources.

[epardo87]

I realized that the source query was the one duplicating values, I erased the relationship arrows inside the source query and linked them again in order.

thanks!

[pbaldy]

Happy to help!