Re: sort by on two columns - Mailing list pgsql-sql

From Michael Glaesemann
Subject Re: sort by on two columns
Date
Msg-id 85E086DE-3D99-11D8-A298-000A95C88220@myrealbox.com
Whole thread Raw
In response to Re: sort by on two columns  ("Andy Lewis" <jumboc@comcast.net>)
Responses Re: sort by on two columns
List pgsql-sql
On Jan 2, 2004, at 8:55 PM, Andy Lewis wrote:
> Yes, I understand this but, I would like to have the results of both
> "table1.name, table2.name"
> sorted as one column.
>
> Is this possible?

So you want one column of name, including names from both table1 and 
table2? In that case, you need to use UNION, I believe. If it's 
something else, I'm not sure I understand what you're asking. Perhaps 
you could include a sample of what you're getting, along with what 
you'd like to see?

Michael Glaesemann
grzm myrealbox com



pgsql-sql by date:

Previous
From: "Andy Lewis"
Date:
Subject: Re: sort by on two columns
Next
From: Adam Ruth
Date:
Subject: Re: sort by on two columns