I am not so into SQL and I have the following problem.
So basically I have a table containing the following fields:
// SOME OTHER FIELDS IRRILEVANT FOR MY QUERY
a.geographical_position AS point1,
a.geographical_position AS point2
FROM accomodation a
where a.id = 31 and a.id = 32
I think you can do it with a
SELECT a1.geographical_position AS point1, a2.geographical_position AS point2 FROM accomodation a1 JOIN accomodation a2 ON a1.id=31 and a2.id=32
The query you have currently is wrong as the
id can not have 2 values at the same time.