On Fri, 04 Apr 2008 00:35:01 -0400,
Colin Wetherbee <[EMAIL PROTECTED]> wrote:
[...]
> SELECT foo - bar AS baz FROM ( SELECT a.a + b.a AS foo, a.b + b.b AS
> bar FROM a JOIN b ON a.id = b.id ) AS subtable;
> Although, I'm not really sure that's The Right Way to do it.
Thanks Colin, yes, I thoug
Seb wrote:
---<---cut here---start-->---
SELECT table1.col1 - table2.col1 AS diff1,
table1.col2 + table2.col2 AS sum1,
sum1 - diff1
FROM table1 INNER JOIN table2 ON (table1.id = table2.id)
---<---cut here---end>--
Hi,
I have a SELECT statement that is a bit involved in terms of
calculations, so I wanted to set up some column aliases and refer to
them further down the select list:
---<---cut here---start-->---
SELECT table1.col1 - table2.col1 AS diff1,
table1.col2 + t
