Razzak, That is pretty awesome.
Any chance you are thinking of adding this option to the SELECT command? That would really blow my socks off!!!!!! Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Friday, March 14, 2014 12:00 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Tip of the Day: JOIN, INTERSECT, SUBTRACT, and UNION -Temporary Table Support Friday, March 14, 2014 Tip of the Day: JOIN, INTERSECT, SUBTRACT, and UNION - Temporary Table Support Product.: R:BASE eXtreme 9.5 (32/64) Build...: 9.5.4.30310 or higher www.rupdates.com Keywords: JOIN, INTERSECT, SUBTRACT, UNION, TEMPORARY Section.: Commands, Temporary Tables Did you know that a TEMPORARY option has been enhanced for the JOIN, INTERSECT, SUBTRACT, and UNION commands, to support the creation of a temporary table? The following example uses the JOIN command to create ProdDetail as a temporary table: JOIN ProdLocation USING Model WITH Product USING Model + FORMING TEMPORARY ProdDetail The following example uses the INTERSECT command to create RepSales as a temporary table: INTERSECT Employee WITH SalesBonus FORMING TEMPORARY RepSales + USING EmpLname, EmpID, HireDate, NetAmount, TransDate, Bonus, BonusPct The following example uses the SUBTRACT command to create NoBonus as a temporary table: SUBTRACT SalesBonus FROM Employee FORMING TEMPORARY NoBonus The following example uses the UNION command to create SalesRepHistory as a temporary table: UNION Employee WITH SalesBonus FORMING TEMPORARY SalesRepHistory Enjoy the showcase and pride of our eXpanded R:Dream Team! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase www.Razzak.com www.RazzakMemon.com -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
