3 lines
305 B
SQL
3 lines
305 B
SQL
SELECT CONCAT(lastname,' ',middleinitial,' ',firstname) as name, isbn, log_date
|
|
FROM library.dbo.member LEFT OUTER JOIN library.dbo.reservation ON library.dbo.member.member_no = library.dbo.reservation.member_no
|
|
WHERE library.dbo.member.member_no IN (250, 341, 1675) ORDER BY library.dbo.member.member_no; |