daily pastebin goal
49%
SHARE
TWEET

Untitled

a guest Dec 11th, 2018 50 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select m.FirstName,m.lastname,
  2. (select count(*)
  3. from loanhist as l
  4. where (l.member_no=m.member_no
  5. or l.member_no in
  6. (select j.member_no
  7.  from juvenile as j
  8.  where j.adult_member_no=m.member_no))
  9.  and year(l.in_date)=2001 and month(l.in_date)=12) as il_ksiazek
  10. from member as m
  11. inner join adult as a
  12. on a.member_no=m.member_no
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Pastebin PRO 'WINTER SPECIAL'!
Get 40% OFF Pastebin PRO accounts!
 
Top