One to many problem

[Ron in NYC]

Hi, I'm running a simple query joining two sets of data. They are joined on 2 fields. The table on the One side has a total of 59 records, the table on the many side has over 200. Only one record on the Many side might match with a record on the One side.

Despite there being no records to match on a number of records on the One side, the result is producing multiple rows with the same data and blanks from the many side.

Why isn't my result limited to the number of records in One side of my query? There should be only 59 records.

 

[pbaldy]

What is the SQL of the query? You may have LEFT/RIGHT instead of INNER.

 

[Ron in NYC]

Hi. I didn't do in SQL. I just used the query grid.

 

[pbaldy]

The query grid creates sql. Change the view and can see and copy it.

 

[bob fitz]

Hi. I didn't do in SQL. I just used the query grid.

All queries have a SQL statement. You can write it directly or you can use the query design grid as you did which will write the statement for you. Click on Views and select "SQL View" which will show the actual SQL Statement for that query. Copy and paste that here.