Re: SQL query

"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