MySQL Forums
Forum List  »  Newbie

Re: sync records on common values
Posted by: smm samm
Date: October 31, 2018 11:57AM

I am novice maybe I do not use good term for my meaning, please see:

1 A C Z F G
2 G Q R C

record 1 has C and G common with Record 2
now 1 has not R and Q thus we must have
1 A C Z F G + Q and R
and Record 2 has not A,Z and F thus we must have:
2 G Q R C + A,Z and F
thus at the end we have:

1 A C Z F G Q R
2 G Q R C A Z F

I need all records Respectively in the queue from top to bottom.

Options: ReplyQuote

Written By
October 31, 2018 01:45AM
October 31, 2018 12:02PM
Re: sync records on common values
October 31, 2018 11:57AM

Sorry, only registered users may post in this forum.

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.