MySQL JOIN query with specific column name

Completed Posted Jun 23, 2015 Paid on delivery
Completed Paid on delivery

Need help with a MySQL JOIN query with specific column name. Two tables need to be merged into one, both are linked with an ID, values are same, but column names differ (id and ID; capitalized and non-capitalized). Tried INNER JOIN and then INSERT INTO, but didn't work.

Probably 1 hour of work.

MySQL

Project ID: #7919862

About the project

16 proposals Remote project Active Jun 23, 2015

Awarded to:

BhargavaB

Hi this is bhargava expert in mysql . i am ready to provide quick and efficient solution Thanks Bhargava

$15 USD in 0 days
(18 Reviews)
3.9

16 freelancers are bidding on average $18 for this job

techvolcano

Hello, Can you please provide the sql dump. We are experts in php/mysql. Ready to start now. Thanks.

$30 USD in 1 day
(107 Reviews)
6.1
Sonicoders

I have 3 years experience in web development I can provide you the solution quickly inbox me for more details..

$13 USD in 1 day
(75 Reviews)
5.5
prakashmondal

A proposal has not yet been provided

$25 USD in 1 day
(41 Reviews)
5.2
spencerb

I've been doing SQL for 14 years - I could probably do this in about 10 minutes. capitalization doesn't matter...

$30 USD in 0 days
(21 Reviews)
4.9
aksharkthakkar

hello i have done lot of project on sql lets start work on it and complete this problem as much as possible

$12 USD in 0 days
(11 Reviews)
5.1
BitSDestiny

I am 8+ Years of Experienced Software Developer. ASP .Net , C# , VB .Net , Visual Basic, Excel VBA , MS SQL Server , MYSQL , Oracle , MS Access, Crystal Report, Telerik , Bootstrap , HTML 5 , CSS , Java Script are my More

$30 USD in 1 day
(5 Reviews)
4.7
SantiSoftware

A proposal has not yet been provided

$17 USD in 1 day
(1 Review)
0.4
vanpan7

Dear Hiring Manager, I will begin by telling you that I am Oracle Certified Professional. I have extensive knowledge in creating SQL queries right from scratch. In oracle and MySql. Pl. share your database details. More

$16 USD in 1 day
(0 Reviews)
0.0
stevenahjing90

i'm doing goo with mysql query, please let me to solve your problem, kindly pass me the job info so that i can help you figure out as soon as possible, thanks.

$15 USD in 1 day
(0 Reviews)
0.0
OchOyuka

A proposal has not yet been provided

$10 USD in 1 day
(0 Reviews)
0.0
NevilDoshi

A proposal has not yet been provided

$16 USD in 1 day
(0 Reviews)
0.0
AdityaK129

I m good at mysql queries like join .

$15 USD in 1 day
(0 Reviews)
0.0