Hi Andy,
On Jan 2, 2004, at 7:15 PM, Andy Lewis wrote:
Is it possible to sort by two columns? Using the query below?
SELECT table1.name, table2.name, FROM table1,
table2 WHERE table1.id = table2.id ORDER BY
I want to be able to sort the names select from two different tables
and
two different
Title: Message
SELECT * FROM customers ORDER BY last_name,
first_name
Works for me.
- Original Message -
From:
Andy Lewis
To: [EMAIL PROTECTED]
Sent: Saturday, January 03, 2004 8:15
AM
Subject: [SQL] sort by on two
columns
Hi
All,
Is it possible to
Sounds like you may want to concatenate the columns:
... order by table1.name || table2.name
The sorting would then be performed on both of the them as though they
were one column.
Adam Ruth
On Jan 2, 2004, at 8:04 PM, Michael Glaesemann wrote:
On Jan 2, 2004, at 8:55 PM, Andy Lewis wrote:
Ye
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
Andy Lewis
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] sort by on two columns
Hi Andy,
On Jan 2, 2004, at 7:15 PM, Andy Lewis wrote:
> Is it possible to sort by two columns? Using the query below?
>
> SELECT table1.name, table2.name, FROM table1,
> table2 WHERE table1.id = table2.id O
