CODEWITHSUNDEEP
postgresqlsyntax-error
user9688766
user9688766

Reputation: 13

Postgres Error in query: ERROR: syntax error at or near "Select"

I am receiving the following:

Error in query:

ERROR: syntax error at or near "Select" LINE 4: (Select remoteaddr, count(remoteaddr) remoteaddrCount

Select Tim1.remoteaddr,Tim1.remoteaddrCount,  Tim2.domain_id
From domain_visitors

(Select remoteaddr, count(remoteaddr) remoteaddrCount
From domain_visitors
Group by remoteaddr
Having count(remoteaddr)>500) Tim1,

(Select distinct remoteaddr, domain_id
From domain_visitors) Tim2
Where Tim1.remoteaddr=Tim2.remoteaddr

Upvotes: 1

Views: 8094

Answers (2)

JGH
JGH

Reputation: 17836

You are missing a comma between the 1st table in the FROM and the expression creating Tim1

Select Tim1.remoteaddr,Tim1.remoteaddrCount, Tim2.domain_id 
From domain_visitors,  -- <-- MISSING COMMA 
  (Select remoteaddr, count(remoteaddr) remoteaddrCount 
     From domain_visitors 
     Group by remoteaddr 
     Having count(remoteaddr)>500) Tim1,
  (Select distinct remoteaddr, domain_id 
     From domain_visitors) Tim2 
Where Tim1.remoteaddr=Tim2.remoteaddr

Upvotes: 0

Mabu Kloesen
Mabu Kloesen

Reputation: 1358

It seems like you have exuberancy table name domain_visitors after From and before the sub query.

Let try again with 

Select Tim1.remoteaddr,Tim1.remoteaddrCount, Tim2.domain_id From 
(Select remoteaddr, count(remoteaddr) remoteaddrCount From domain_visitors Group by remoteaddr Having count(remoteaddr)>500) Tim1
JOIN 
(Select distinct remoteaddr, domain_id From domain_visitors) Tim2 ON Tim1.remoteaddr=Tim2.remoteaddr

Hopefully this answer will help you.

Upvotes: 1

Related Questions