Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

joins

 
rama rajesh
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can you explain the difference between these 2 queries.


 
Agador Paloi
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi -
Did you try running these queries?

What did you get when you ran this?




Agad
 
Tom Reilly
Rancher
Posts: 618
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I guess the point I was making is that the
query syntax is invalid.

 
Janeice DelVecchio
Saloon Keeper
Posts: 1808
12
Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm pretty sure the correct syntax is as follows... and they are equivalent:

 
rama rajesh
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1808
12
Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rama,

Please start a new thread for your question. To post in an unrelated thread is considered hijacking and, well, "not nice".
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic