Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. SELECT ISNULL(SUM(Stocking_Count),0)
  2. FROM Fish_Stocking
  3. where fish_id = 'B2017-1' and tank_id = 'H A01' and
  4. Date_Assigned = '2017-02-02' and stocking_date <= '2017-03-28'
  5.  
  6. SELECT ISNULL(SUM(NO_FISH_SWUM_OFF),0)
  7. FROM Swim_Thru
  8. where Dest_fish_id = 'B2017-1' and Dest_tank_id = 'H A01' and
  9. Dest_Date_Assigned = '2017-02-02' and date_swim_thru <= '2017-03-28'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement