Closed

Small SQL Query Needed

This project was awarded to OShuqair for $30 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
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.

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