| Subject | How to ORDER BY a field produced by a singleton select? |
|---|---|
| Author | Raymond Kennington |
| Post date | 2002-12-25T06:07:19Z |
The following is required for allowing ordering by a looked-up field that is
computed.
SELECT
A.ID,
A.NAME,
(SELECT B.NAME from B WHERE B.ID = A.BID) AS B_Name
FROM A
ORDER BY B_Name
It doesn't work, so how should one do this?
--
Raymond Kennington
Programming Solutions
W2W Team B
computed.
SELECT
A.ID,
A.NAME,
(SELECT B.NAME from B WHERE B.ID = A.BID) AS B_Name
FROM A
ORDER BY B_Name
It doesn't work, so how should one do this?
--
Raymond Kennington
Programming Solutions
W2W Team B