[![enter image description here](https://i.stack.imgur.com/1AQmy.png)](https://i.stack.imgur.com/1AQmy.png)

I want to select all skill\_id where job\_id equals = 1 , is there a way around this using a simple sql query ?

in this example : i want sql to return 1 and 2 as skill\_id
thanks