On Saturday 14 January 2006 13:09, A. Kretschmer wrote:
> am 14.01.2006, um 13:02:48 + mailte Alan Chandler folgendes:
> > select name, id, transaction.date as tdate, description, amount
> > from account join transaction on name=dst where name ='Sarah'
> > order by tdate asc;
> >
> > name |
On Sat, 14 Jan 2006 13:02:48 +
Alan Chandler <[EMAIL PROTECTED]> wrote:
> select name, id, transaction.date as tdate, description, -amount as amount
> from account left join transaction on name=src where name = 'Sarah'
> union
> select name, id, transaction.date as tdate, description, amount
>
am 14.01.2006, um 13:02:48 + mailte Alan Chandler folgendes:
> select name, id, transaction.date as tdate, description, amount
> from account join transaction on name=dst where name ='Sarah'
> order by tdate asc;
>
> name | id | tdate|description| amount
> ---+
Just joined the list and have seen in the archive the thread on orderby. But
mine seems different.
I have a finanancial application with account and transactions which go
between accounts (source and destination) but in which one either can be
null.
I am attempting to read an account and sort
