I my experience, it seems to start returning that and similar errors after three tables in the view. I have one view that uses 12 tables (gotta love 3NF) and to make it work, I built it with layered views, each with two tables max and the required foriegn keys to link them up to a parent view. i.e pers_rank as select pers.* , ranks.rank_code from pers, rank where pers.rank_key = rank.rank_key
pers_section, as select pers_rank.*, section.uic, section.sec_name from pers_view, section where ..... you get the idea untill finally all required data is in a complex view.

Maybe one of the others here knows a better work around.