Changes between Version 4 and Version 5 of QueryOptimization

Timestamp:

05/31/26 00:23:28 (2 weeks ago)

Author:

231101

Comment:

--

QueryOptimization

@@ -248 +248 @@
 
 {{{#!sql
-CREATE OR REPLACE VIEW vw_member_borrowing_history AS
-SELECT
-m.member_id,
-m.first_name,
-m.last_name,
-b.title,
-br.borrow_date,
-br.return_date,
-br.due_date,
-br.return_status
+CREATE OR REPLACE VIEW public.vw_member_borrowing_history AS
+SELECT 
+    m.member_id,
+    m.first_name,
+    m.last_name,
+    b.title,
+    br.borrow_date,
+    br.return_date,
+    br.due_date,
+    br.return_status
 FROM borrowing br
 JOIN member m ON m.member_id = br.membership_id
-JOIN book b ON br.book_id = b.book_id;
+JOIN book b ON br.book_id = b.book_id
+WHERE m.member_id IS NOT NULL;
 }}}