On 9 December 2015 at 00:44, Chris Withers <ch...@simplistix.co.uk> wrote:
> Hi All, > > I hope this is quite a simple one... > > I have a fixtures table containing home_club and away_club, and I'd like > to select the distinct list of clubs contained in all rows but in either > the home_club or away_club columns. > > How would I do that? > Use UNION: select home_club from fixtures UNION select away_club from fixtures; -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
