Click here to Skip to main content
       

Database

 
GeneralRe: Older generation SQL syntax - Oracle Pinmembervanikanc13-Feb-13 11:37 
AnswerRe: Older generation SQL syntax - Oracle PinmemberShameel15-Feb-13 5:17 
QuestionHaving a bad SQL day PinmemberTheComputerMan13-Feb-13 0:40 
AnswerRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 1:20 
Well, [dkm] is an Alias, not a columnname.
 
You would need to have the same expression in the having or where clause as you have in the select clause.
"The ones who care enough to do it right care too much to compromise."
Matthew Faithfull

GeneralRe: Having a bad SQL day PinmemberTheComputerMan13-Feb-13 1:32 
GeneralRe: Having a bad SQL day [modified] PinmemberJörgen Andersson13-Feb-13 1:40 
GeneralRe: Having a bad SQL day PinmemberBernhard Hiller13-Feb-13 4:24 
GeneralRe: Having a bad SQL day PinmemberTheComputerMan13-Feb-13 4:33 
AnswerRe: Having a bad SQL day PinmemberShameel13-Feb-13 1:53 
GeneralRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 1:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.141223.1 | Last Updated 21 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid