Re: ACE Report writing, I'm confused.
In article <30eqvl$59a@emory.mathcs.emory.edu>, alan@po.den.mmc.com (Alan
Popiel) writes:
Michael,
since you stated there can "many (or none) entries in T3" you may want to
format your select as:
select *
from t1, t2, outer (t3)
where t1.CustNum = t2.CustNum
and t3.OrderNum = t2.OrderNum
order by t1.CustNum, t2. OrderNum
you may want to append ", t3.NoteId" to the order by above if there is an
ordering
to the notes in the t3 table.
otherwise your join will only join rows from t1 to t2 where there are
notes in t3.