network profile
|
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 |
