Re: [OT] Business Requirements Analysis... Sort Of

In article <s6f3u3dlalc0i5g0jq4gtilg43kke5nm0o@[EMAIL PROTECTED]
>,
Robert  <no@[EMAIL PROTECTED]
> wrote:
>On Wed, 19 Mar 2008 12:35:35 +0000 (UTC), docdwarf@[EMAIL PROTECTED]
 () wrote:

[snip]

>>(note - this is a shop that runs on files, not on a database)

[snip]

>select name, separation_date, dirty_money
>  from employees emp, 
>          (select employee, sum(amount_paid) as dirty_money
>              from payroll_detail pd
>              where debit_account = '6969'
>                  and payment_date between to_date(20051001) and sysdate
>             group by employee
>             having dirty_money > 0) crook
> where crook.employee = emp.employee
>    and emp.separation_date is not null
>    and emp.division in
>          (select division from divisions where division_name like 
'Midwest%')
>   and emp.start_date >
>          (select min(start_date) from employees where name like
'%Dwarf%')
>
>-- Query preparation time: 5 minutes 

Amount of time spent carefully reading what preceded query preparation 
time: not enough to catch a clear and unambiguous note.

DD