Query multiplying data

[epardo87]

Hello,



I'm running a query from another query [Qry-CertStat] but adding two more columns from two different tables related to that info [tbl-1-2-Estaciones] and [tbl-1-1-Subareas]

what I want is the rows of the query exactly as they appear but adding the corresponding value of the two columns added from tables, this is the SQL:

thanks for your time!

SELECT [Qry-CertStat].Estación, [Qry-CertStat].MaxOfFecha, [Qry-CertStat].Operador, [Qry-CertStat].DíasCert, [Qry-CertStat].Status, [Qry-CertStat].Due, [tbl-1-2-Estaciones].Subarea, [tbl-1-1-Subareas].Área
FROM ([tbl-1-1-Subareas] INNER JOIN [tbl-1-2-Estaciones] ON [tbl-1-1-Subareas].[Subarea] = [tbl-1-2-Estaciones].[Subarea]) INNER JOIN [Qry-CertStat] ON [tbl-1-2-Estaciones].[StationDescription] = [Qry-CertStat].[Estación];

[ranman256]

The joins can multiply data because of what's in the tables.
you must be careful what you join.

[epardo87]

The joins can multiply data because of what's in the tables.
you must be careful what you join.

Thanks ranman,
I did this through the query wizard, don't really know how to do a query through SQL... how can I avoid the Joins?

[aytee111]

When you join two (or more) sets of data you will always get the maximum number of rows - e.g. one row on one side but two rows on the other, this will always result in two rows displayed in the query. If you want only one row then either add more joins or use a query instead of the tables which has only the one record.

[epardo87]

When you join two (or more) sets of data you will always get the maximum number of rows - e.g. one row on one side but two rows on the other, this will always result in two rows displayed in the query. If you want only one row then either add more joins or use a query instead of the tables which has only the one record.

Thank you,

At the end, I deleted all the relationships inside the query and carefully dropped the corresponding value on top of the corresponding column linked, this fixed the problem