8 lines
164 B
SQL
8 lines
164 B
SQL
SELECT member_no, lastname
|
|
FROM library.dbo.member
|
|
WHERE
|
|
(
|
|
SELECT SUM(fine_assessed)
|
|
FROM library.dbo.loanhist
|
|
WHERE member.member_no = loanhist.member_no
|
|
) > 5; |