Advertisement
Guest User

Untitled

a guest
Dec 11th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.33 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement