Skip to content

Instantly share code, notes, and snippets.

@qcom

qcom/query.sql

Last active December 11, 2015 22:09
Show Gist options
  • Save qcom/4667884 to your computer and use it in GitHub Desktop.
Save qcom/4667884 to your computer and use it in GitHub Desktop.
Download ZIP
insert shipping weights into products table
Raw
query.sql
-- 2 Tables: Products(SKU, ShippingWeight, Name, Description ...) and Weights(SKU, ShippingWeight)
select Products.SKU, Weights.ShippingWeight
from Products join Weights
on Products.SKU = Weights.SKU and Products.Vendor = 'MasterLock'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment