At 05:03 PM 5/5/2001 -0400, Bob Powell wrote: >Does anyone know the maximum number of tables that can be used in a select command? Bob, As far as TGRB2000 (ver 6.5+) and higher is concerned, there is NO SET LIMIT. As far as the performance is concerned, that depends entirely on how well the data is structured/indexed and how many rows you expect in ResultSet! A well structured SELECT with 10 tables could return results immediately, while a poorly constructed SELECT with 2 tables (for instance, if you forget your JOIN conditions) could take a long time to execute. Very Best Regards, Razzak. ===================================-============================ R:BASE Developers's Conference: http://www.rbase.com/conference Official R:BASE List Server: mailto:[EMAIL PROTECTED] RBTI Events/Training: http://www.rbase2000.com/events R:DCC Members: http://www.rbase2000.com/rdcc ================================================================ R:BASE, Oterro & R:Tango are registered trademarks of RBTI. ==================================-=============================
