Write SQL query

IN PROGRESS
Bids
43
Avg Bid (USD)
$22
Project Budget (USD)
$10 - $30

Project Description:
Need SQL query written.

Using MSSQL 2010

Table 1-Inventory.LocalSKU
Table 2-InventorySupliers.LocalSKU, InventorySuppliers.BoydQuantityAvailable, InventorySuppliers.SupplierID = 315

I need a query which does the following
I have the same item listed in the InventorySuppliers table under LocalSKU and LocalSKU + 'U1"
example
SKU = 123456789 and 123456789U1

I need the BoydQuantityAvailable in the U1 to = the BoydQuantityAvailable where the U1 doesnt exist.

Query will run as a "top 1000" because its a large query and just loop..

Skills required:
SQL
Hire pghquest
Project posted by:
pghquest United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire oleg21
$ 25
in 3 days
$ 25
in 1 days
$ 35
in 1 days
$ 23
in 1 days
$ 29
in 0 days
$ 35
in 1 days
$ 25
in 0 days
Hire schungur
$ 25
in 1 days
$ 23
in 1 days
$ 45
in 3 days