[comp.databases] Limitations with informix-sql

oechslin@aut.UUCP (Oechslin Stephan) (09/04/89)

I've got some problems with the limitations of iniformix-sql. Informix-sql
allows you to work with up to 14 tables in a form. So I'm working with
10 tables. I need to make a join including all 10 tables. It is not 
possible to make it through a single join statement since informix does not
allow joins with more than 8 tables. It is also not possible to  split this 10
 table join in 2 joins (with 1 common column) since informix-sql does 
not allow duplication of columns.

Any way around that?

Thanks for your help.

stephan

e-mail: oechslin@aut.UUCP