Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!iuvax!cica!tut.cis.ohio-state.edu!cs.utexas.edu!uunet!mcsun!cernvax!hslrswi!aut!oechslin
From: oechslin@aut.UUCP (Oechslin Stephan)
Newsgroups: comp.databases
Subject: Limitations with informix-sql
Keywords: informix-sql
Message-ID: <707@aut.UUCP>
Date: 4 Sep 89 11:29:26 GMT
Organization: ascom AUTELCA AG, CH-3073 Guemligen Switzerland
Lines: 16


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