Thanks Sean,

I will do it that way.

Sudheer

--- "Leyne, Sean" <sleyne@...> wrote: >
Sugheer,

>
> > I have a table data like this
> ...
> > Either debit or credit will have only one entry.
>
> Although you could write a SELECT statement, to be
> honest the better
> solution would be to change you table schema to add
> a new column to
> 'mark' the details rows you need to report on. Is
> that an option?
>
> A SELECT statement would perform VERY VERY POORLY.
>
>
> Sean
>
> ------------------------ Yahoo! Groups Sponsor
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>

________________________________________________________________________
Download Yahoo! Messenger now for a chance to win Live At Knebworth DVDs
http://www.yahoo.co.uk/robbiewilliams