Mike, It all depends on what you hope to accomplish. The INTERSECT command can be replaces by a VIEW using SELECT ... INNER JOIN syntax
Here is the INTERSECT syntax: INTERSECT tblname1 WITH tblname2 FORMING tblname3 USING collist Equivalent VIEW syntax might look like: CREATE VIEW tblname3 (columnNameList) AS SELECT + T1.columnsfromtbl1, T2.columnsfromtbl2 FROM tblname1 T1 INNER JOIN + tblname2 ON T1.col1=T2.col1 AND T1.col2=T2.col2 [etc] You could use the VIEW directly or PROJECT TEMPORARY table using the defined view. Check HELP for complete syntax including using WHERE clause to limit items selected. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ________________________________ From: mike epstein sony viao office <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Sat, July 3, 2010 9:39:01 AM Subject: [RBASE-L] - staticdb Good morning I have used the intersect command in an eep with rbase76 to manipulate data in multiple tables . In version 9 I have encountered problems with speed on the network and have implemented the staticdb on setting to increase the speed It seems that the intersect command will not work with staticdb set to on . I’m sure there is a work around any suggestions? Mike Epstein
