I can't seem to figure out the query for what seemingly should be an easy
thing.

I have a table "user" which contains the following columns and data:

userid locationid
1 1
2 2
3 1
4 3

I need to return a list of locationid's based on a specific userid's
locationid.

For example if userid equals 1, the query would return

userid location
1 1
3 1


Thanks.