Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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,
- Product_Brought.Quantity
- from Storage_Facility
- join product on (Storage_Facility.Product=product.Product_ID)
- join Check_Gauge on (Storage_Facility.Storage_Facility_ID=Check_Gauge.Storage_Facility_ID)
- join Product_Brought on (Storage_Facility.Storage_Facility_ID=Product_Brought.Storage_Facility)
- Where Check_Gauge.Product_ID = 2 and Check_Gauge.Date_Recorded='2014-10-14'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement