I am wondering what the limit is on the number of joins in a View or a Select.
Background: I have many tables with similar flags such as Active, Inactive, High, Medium, Low. I am storing the flags in a flag table and then putting an int4 foreign key to the flag in the data tables. Some data tables may have up to 15 flags, as well as 30 or 40 other foreign keys. They're all left outer joins. Is this a problem for a view?
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297
