Select u1.displayname,u1.location,u2.location from users ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Beer, Wine & Spirits Meta Stack Exchange

Q&A for alcoholic beverage aficionados and those interested in beer, wine, or spirits

Select u1.displayname,u1.location,u2.location from users u1 left join users u2 
ON u1.location=u2.location
where u1.location like '%new%'
order by u1.location

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results