MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Get all Child nodes and check for duplicate or repeated
Posted by: Peter Brawley
Date: January 19, 2017 08:41AM

select a.product_id
from a join b using(product_id)
union
select b.subproduct_id
from a join b using(product_id) ;

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


Subject
Written By
Posted
Get all Child nodes and check for duplicate or repeated
MuraliDharan V
January 06, 2017 03:15PM
Re: Get all Child nodes and check for duplicate or repeated
Peter Brawley
January 06, 2017 04:51PM
Re: Get all Child nodes and check for duplicate or repeated
MuraliDharan V
January 19, 2017 07:35AM
Re: Get all Child nodes and check for duplicate or repeated
Peter Brawley
January 19, 2017 08:41AM


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.