Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select m.FirstName,m.lastname,
- (select count(*)
- from loanhist as l
- where (l.member_no=m.member_no
- or l.member_no in
- (select j.member_no
- from juvenile as j
- where j.adult_member_no=m.member_no))
- and year(l.in_date)=2001 and month(l.in_date)=12) as il_ksiazek
- from member as m
- inner join adult as a
- on a.member_no=m.member_no
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement