MySQL Forums
Forum List  »  Newbie

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.

Options: ReplyQuote


Subject
Written By
Posted
joining tables
mk
June 24, 2005 05:46AM
June 26, 2005 01:41AM
mk
June 27, 2005 12:09AM
mk
June 27, 2005 12:10AM


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.