aspose file tools*
The moose likes Oracle/OAS and the fly likes joins Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "joins" Watch "joins" New topic
Author

joins

rama rajesh
Greenhorn

Joined: Jun 22, 2010
Posts: 28
can you explain the difference between these 2 queries.


Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
Hi -
Did you try running these queries?

What did you get when you ran this?




Agad
Tom Reilly
Rancher

Joined: Jun 01, 2010
Posts: 618

You use the using clause when you are joining two tables that have the same column name. Here is a link to a page that explains the syntax: http://www.oracle-base.com/articles/9i/ANSIISOSQLSupport.php
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
I guess the point I was making is that the
query syntax is invalid.

Janeice DelVecchio
Saloon Keeper

Joined: Sep 14, 2009
Posts: 1623
    
  10

I'm pretty sure the correct syntax is as follows... and they are equivalent:


When you do things right, people won't be sure you've done anything at all.
rama rajesh
Greenhorn

Joined: Jun 22, 2010
Posts: 28
Tom Reilly wrote:
You use the using clause when you are joining two tables that have the same column name. Here is a link to a page that explains the syntax: http://www.oracle-base.com/articles/9i/ANSIISOSQLSupport.php

thanks a lot to tom(link helped me) and others who send the responses .

when joins are there, how subqueries help us?
want to know whether outer query executed first or inner query executed first? how the following query is executing and giving some result. when i tried in similar manner getting exception like "too many rows selected..."




rama rajesh
Greenhorn

Joined: Jun 22, 2010
Posts: 28
How to identify which is a subquery and which is correlate subquery?i understand the difference between correlated subquery and subquery
(got information like subqeury executed only one and correlated subquery executes several times)

Janeice DelVecchio
Saloon Keeper

Joined: Sep 14, 2009
Posts: 1623
    
  10

Rama,

Please start a new thread for your question. To post in an unrelated thread is considered hijacking and, well, "not nice".
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: joins
 
Similar Threads
Cannot understand MySqlQuery Working.
Confusion when joining two tables
How to use Left outer join in EJB 3.0
Right Outer Join in Oracle
Stored procedure which returns array