Need this accomplished only in MySQL.
Below is the high level requirement. Refer attachments for more details on requirement, table structure, before/after comparison sample result set etc.
• Need a query/SP to compare the data of table1 and table2
• If a record in table1 has only one match found in table2 --> table1.ref_id = table2.rec_id, comp_result = 'Match'
• If a record in table1 has multiple matches found in table2 --> table1.ref_id = table2.rec_id of the first match where table2.rec_id doesn't exist in table1.ref_id, comp_result = 'Match'
• Value of ref_id should be unique.
10 freelancers are bidding on average ₹1365 for this job
hi I have more than 10 years of professional experience in sql development and optimisation and worked in more than 300 projects in different database like Oracle,mysql/db2/ [login to view URL] discuss your requirements
I can develop a query to compare a two tables according to described requirements. I am highly qualified Senior SQL developer and I have a more than 10 years of professional experience.
Hi, nice to greet you, my name is Alex, I would be interested in working on your project, I have immediate availability, I have great knowledge in MySQL I remain attentive to your comments Regards
Your query is resolved, I have 10 year of experience working in database. i will provide you query within 15 mints and also do some change on same day if required.