Thanks a lot.... I will proceed based on the comments. With Regards Jayaram
On Sun, May 2, 2010 at 11:32 AM, Lily Wei <[email protected]> wrote: > Hi Jayaram: > On top of Derby reference menu, this is some join example with using > keyword for you to reference too. > http://www.java2s.com/Tutorial/Oracle/0140__Table-Joins/SimplifyingJoinswiththeUSINGKeyword.htm > > Lily > > ________________________________ > From: Knut Anders Hatlen <[email protected]> > To: [email protected] > Sent: Sun, May 2, 2010 5:33:15 AM > Subject: Re: Buddy Testing of Using Clause > > On 05/ 1/10 01:23 PM, Jayaram Subramanian wrote: >> Hi, >> >> I am trying to test along the comments. I am taking the 10.5 as >> reference .. Is that correct? > > The USING clause was not supported in 10.5, so you won't find anything > about it in the 10.5 manuals. You can find the latest development > version of the reference guide here: > http://db.apache.org/derby/docs/dev/ref/ > >> Also when i saw 10.5 reference guide for >> join i saw the following sql >> >> SELECT SAMP.EMP_ACT.*, LASTNAME >> FROM SAMP.EMP_ACT JOIN SAMP.EMPLOYEE >> ON EMP_ACT.EMPNO = EMPLOYEE.EMPNO >> >> Is there any samp schema which gets installed along with Derby install? >> > > I don't think so. I suspect this example is based on a DB2 sample > database (at least it looks like many of the examples in the DB2 manual > use a similar database). Many other examples in the Derby manuals use > toursdb, which you can find under java/demo/toursdb/toursdb after you > have run ant all. > > -- > Knut Anders > > >
