"Michael Thorsen" <mthorsen1980@gmail.com> writes:
> ... I gave a simple example above, but the query runs over 2 tables
> with about a million entries in each. So I am unable to verify what is
> wrong, but I know the count is incorrect as I should not have more than what
> is in the user_table.
You could easily get a count larger than the number of rows in
user_table, if there are rows in user_table that join to multiple rows
in the locations table. So look for duplicated data in locations ...
regards, tom lane