Count unique records with subtable

[blairhenry]

Hi,

I have a query that accesses information from 2 tables. One is a master and the other is a sub-table.

The relationship is one lossid in the master can have many records in the subtable.

I need to do a count of how many unique records exist in the master table but I keep getting the total number of records including the duplicates from the subtable.

Any help would be appreciated, I'm probably not explaining it correctly.

 

[Pat Hartman]

You can't count the number of 1-side rows if the query includes a join to the many-side table. Remove the join to the many-side table.