If I have three tables
Customers Orders Order items
id -------------------- custid
id --------------------- ordid
Knowing that three tables in a view does not work. would the correct approach be as follows:
view1 view2 view3
customers orders view1
order items view2
and generate reports using view3
Dennis Collins
TRACKUM, Inc.