Closed

Compare two table data in MySQL

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.

Skills: MySQL, SQL, Database Programming, Database Development

See more: mysql compare two tables to find matched records, mysql compare two tables structure, how to compare data in two tables in sql, sql query to compare two tables and find records with matches, mysql compare two tables from different databases, mysql compare all columns in two tables, mysql compare two columns from different tables, mysql compare two tables to find unmatched records, getafreelancercom grab web data mysql table, iphone collect data mysql table, mysql php drowdown menu table set value table, convert xml data mysql table, lucene indexing data mysql table, css formatting table data php mysql, gathering data mysql table, retrieving data mysql table codeigniter, grab certain data mysql table, export data mysql table word document php, ajax mysql dynamic checkbox table data, display table data mysql joomla

About the Employer:
( 6 reviews ) Coimbatore, India

Project ID: #27483677

10 freelancers are bidding on average ₹1365 for this job

TEKSCENT

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

₹1500 INR in 1 day
(17 Reviews)
4.1
SqlDevelopment

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.

₹3000 INR in 1 day
(18 Reviews)
3.7
groverjatin2008

Hello employer, I would like to bid for your project work pertaining to writing SQL query or SP Here is my linkedin profile: [login to view URL] I am data engineer and working in are More

₹1500 INR in 7 days
(6 Reviews)
3.5
kchoudhary95

I am a full-stack developer with a career in the IT industry of over 4 years. I have rich experiences with many people and they always get the best result. It's a piece of cake for me! You'll not waste your GOLD TIME. More

₹1050 INR in 1 day
(3 Reviews)
2.3
kreativesystem91

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

₹800 INR in 1 day
(2 Reviews)
1.1
cyberexpert11

hi I am a professional full stack web developer having experience of more than 12 years. Allow me to do this project and I assure you a quality work.

₹1500 INR in 1 day
(0 Reviews)
0.0
Schiliuta57

Hi Sir! It's a pleasure to meet you. I'd really like to work with you on this one if possible! I am a new developer here, but have much experience in web development. Looking through your attachment, I clearly got to More

₹1500 INR in 7 days
(0 Reviews)
0.0
muhammadfaisal92

I have 6 year of experience in database development , i am pro with query optimization and SP writing .

₹1200 INR in 1 day
(0 Reviews)
0.0
rkundlik

Greeting!!! I reviewed your requirement, I am Oracle Certified Data Scientist,Analyst Professional having over 5+ years experience in Database development covering multiple technologies like oracle, mysql,sql plsql. More

₹600 INR in 1 day
(0 Reviews)
0.0
RaviPrajapat7

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.

₹1000 INR in 1 day
(0 Reviews)
0.0