joining tables
Posted by:
mk
Date: June 24, 2005 05:46AM
hi all,
I have a diagnostic table of 39,000 rows which contains non-unique serial numbers , age info and diagnostic data.
I wish to extract all data from this table but only for rows with distinct serial no.
I extracted only the distinct serial nos.i.e 19,000 rows and created a table.
Then when i join these 2 tables querying for all data with join saying table #1.serialno=table#2.serialno
But the above returns data for all the 39,000 rows. whereas i wished the data would be for 19,000 rows.
Could anyone pls. let me know how to go about it.
Many thanks in advance.
Subject
Written By
Posted
joining tables
June 24, 2005 05:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.