Advertisement
Guest User

Untitled

a guest
Nov 21st, 2014
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. Select Storage_Facility.Storage_Facility_Name as Tank, Product.Product_tYPE as Grade, Storage_Facility.Capacity_MT, Storage_Facility.Capacity_Gals, Check_Gauge.ActualQuantityInStock as Beginning_Balance,
  2. Product_Brought.Quantity
  3. from Storage_Facility
  4. join product on (Storage_Facility.Product=product.Product_ID)
  5. join Check_Gauge on (Storage_Facility.Storage_Facility_ID=Check_Gauge.Storage_Facility_ID)
  6. join Product_Brought on (Storage_Facility.Storage_Facility_ID=Product_Brought.Storage_Facility)
  7. Where Check_Gauge.Product_ID = 2 and Check_Gauge.Date_Recorded='2014-10-14'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement