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..."