Bob,
I have used selects with at least 12 tables referenced in it using table
correlation names. I have tried up to 14 tables but had problems with
Cartesian product.
Hope this gives you some help.
Rich S.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Bob Powell
Sent: Saturday, May 05, 2001 5:04 PM
To: [EMAIL PROTECTED]
Subject: Max number of tables in a select command
Does anyone know the maximum number of tables that can be
used in a select command?
SEL LASTNAME FIRSTNAME ADDR1 STATELONG FROM PEOPLE,
ADDRESS, STATELU WHE PEOPLE.ID = ADDRESSS.ID
How many tables can I list separated by commas before it no
longer works or is such a performance hit that it isn't
worth it?
----------------------
Bob Powell
The Hotchkiss School
Lakeville, Connecticut
Systems Administrator
[EMAIL PROTECTED]
