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

Question

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

Yes, that is bad syntax alright. If you tell us what you are trying to achieve, maybe someone can help. — Laurenz Albe
– Laurenz Albe, Commented May 2, 2018 at 11:10
You need to JOIN those derived tables somehow. from domain_visitors JOIN (select ...) as tim1 on tim1.some_col = domain_visitors.some_other_col JOIN (select ... ) tim2 on Tim1.remoteaddr=Tim2.remoteaddr — user330315
– user330315, Commented May 2, 2018 at 11:23

Mabu Kloesen · Accepted Answer · 2018-05-02 11:10:26Z

1

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.

answered May 2, 2018 at 11:10

Mabu Kloesen

1,3687 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user9688766 Over a year ago

Thank you very much

JGH · Accepted Answer · 2018-05-02 11:10:56Z

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

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related