MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Join to return only matching rows
Posted by: Manoj Talukdar
Date: November 07, 2014 06:53AM

I have two table with one common column "OrderID", both table have 4 records with orderid 1, When I do query using join it returns 16 records (4x4=16) but I want only 4 matching records.
How can i do this ????

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Join to return only matching rows
Manoj Talukdar
November 07, 2014 06:53AM
Re: Join to return only matching rows
Peter Brawley
November 07, 2014 10:17AM


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.