Closed

Small SQL Query Needed

This project was awarded to OShuqair for $30 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Total Bids
46
Project Description

I have a small SQL query that I need written. I have three tables, I don't know if they all need to be used, but basically I need Table A and Table C to be compared, if there is an ID that is in Table A that is not in Table C, then in Table C the ID is to be added along with value in another cell in that row. See below for an example:

Original Table A:

-------------------------

Sku | Status

-------------------------

ABC | Enabled

DEF | Enabled

GHI | Enabled

JKL | Disabled

MNO | Enabled

Original Table C:

-------------------------

Sku | Status

-------------------------

ABC | Enabled

DEF | Enabled

GHI | Enabled

After Query Table C:

-------------------------

Sku | Status

-------------------------

ABC | Enabled

DEF | Enabled

GHI | Enabled

JKL | Disabled

MNO | Disabled

Not looking to spend more than $30 on this, $40 if you can be online to screen share with me.

Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online