Re: ACE Report writing, I'm confused.
In article <Ct5AzL.16p@world.std.com>, mtiernan@world.std.com (Michael C Tiernan) says:
> select *
> from t1, t2 { no 'outer' }
> where t1.custnum = t2.custnum
into temp aa; { aa will only contain custs what HAVE t2 orders }select aa.*, t3.*
from aa, outer t3 { 'outer' because not all t2's have matching t3's }
where aa.ordnum=t3.ordnum
into temp bb; { bb contains both t2's without t3's and t2's with t3's}
select * from bb
order by custnum, ordnum
endformat
before group of custnum
print "CUST #", custnum, " ", custname
before group of ordnum
print " ORDER #", ordnum
on every row
print " ", t3
end
Try this out using ACE. You should get what you want.
owwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww!
Don't put your fingers in the lawnmower.
nurosa@itsa.ucsf.edu David A. Kell