Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
4
Newest
 Supporter
Impact
~437 people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Sep
15
comment Select only neighbour rows who pass a where-test
I don't understand that at all. What are you doing? What is location2, for example? Why is there no , between the tables in your FROM clause?
Sep
15
comment Select only neighbour rows who pass a where-test
@Aaron Bertrand: It is on purpose that I don't ask for a database specific answer. If you know an easy solution for database X or Y there is no problem adding it as a solution. The real question is, how to solve it with standard SQL, though. I think every well known database should have some way of solving any task out of the standard solvable task set.
Sep
15
comment Select only neighbour rows who pass a where-test
Yes, I didn't tag it with sqlite3 on purpose. If there are better solutions in other dbs it is great additional information, even if I can't use it right now.
Sep
15
awarded  Supporter
Sep
14
awarded  Student
Sep
14
answered Select only neighbour rows who pass a where-test
Sep
14
awarded  Editor
Sep
14
revised Select only neighbour rows who pass a where-test
deleted 12 characters in body
Sep
14
asked Select only neighbour rows who pass a where-test
Sep
14
awarded  Autobiographer