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! --
