Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
Alias of the table in ORDER BY does not work |
Fri, Jun 22 2018 4:58 AM | Permanent Link |
Informel Data Informel Data, SLU | Hi,
This query works well: Select SubString (FIL1.RECEIPT FROM 1 FOR 7) as RECEIPT From MYTABLE FIL1 Order by RECEIPT But if I use the alias of the table in the Order by, it does not work: Select SubString (FIL1.RECEIPT FROM 1 FOR 7) as RECEIPT From MYTABLE FIL1 Order by FIL1.RECEIPT Any idea? Thanks, |
Fri, Jun 22 2018 12:44 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << But if I use the alias of the table in the Order by, it does not work: >> DBISAM only allows column names in ORDER BY, GROUP BY, and HAVING clauses that are found in the SELECT column expressions, so you would have to write it like this: Select FIL1.RECEIPT, SubString (FIL1.RECEIPT FROM 1 FOR 7) as SUBRECEIPT From MYTABLE FIL1 Order by FIL1.RECEIPT ElevateDB, on the other hand, *does* allow for your original query. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, April 18, 2024 at 10:42 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |