I actually want to second this thumbs up. Sometimes it's the little things that make a big difference.
Regards, Ken Sent from my iPhone > On Mar 14, 2014, at 1:10 PM, Dennis McGrath <[email protected]> wrote: > > 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! > -- > >
