Order by sub-select
От | Daniel T. Staal |
---|---|
Тема | Order by sub-select |
Дата | |
Msg-id | 61849.63.172.115.138.1199898741.squirrel@MageHandbook.com обсуждение исходный текст |
Ответы |
Re: Order by sub-select
|
Список | pgsql-novice |
In the following query: SELECT name, contact, phone, email FROM eforward.address WHERE gsb IN ( SELECT gsb FROM eforward.ibox WHERE ibx IN ( SELECT DISTINCT ibx FROM eforward.partner WHERE pibx = 'MTCBIN')); How would I sort the result by eforward.partner.ibx? I tried an 'ORDER BY' clause in the sub-select, but that doesn't appear to work. (If you drop the outer query, the order does appear to be maintained however.) I'm using postgres 8.1.0. Daniel T. Staal --------------------------------------------------------------- This email copyright the author. Unless otherwise noted, you are expressly allowed to retransmit, quote, or otherwise use the contents for non-commercial purposes. This copyright will expire 5 years after the author's death, or in 30 years, whichever is longer, unless such a period is in excess of local copyright law. ---------------------------------------------------------------
В списке pgsql-novice по дате отправления: