On 10/28/2011 4:28 PM, Pete wrote:
I have another variation of this issue:
SELECT col1 - col2 as Total, Total * price FROM tst
... gives an error " no such column: Total". I can just repeat "col1 - col2"
of course, but wondering if there is a way to refer to Total within the
SELECT.
This is
I have another variation of this issue:
SELECT col1 - col2 as Total, Total * price FROM tst
.. gives an error " no such column: Total". I can just repeat "col1 - col2"
of course, but wondering if there is a way to refer to Total within the
SELECT.
Thanks,
Pete
> >
> > Message: 6
> >
2 matches
Mail list logo