Limit for number of Joins in a View? Version 8.1.4 on Redhat 9

[MargaretGillon@xxxxxxxxxxxxxx]

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