Changes between Version 8 and Version 9 of ImportantUseCase012

Timestamp:

01/13/25 03:05:02 (2 days ago)

Author:

201205

Comment:

--

ImportantUseCase012

@@ -28 +28 @@
 
 {{{
-select b.title, b.author, b.language, b.imageurl, l.condition, u.username, u.city, u.neighborhood, g.genre
-from book b join library l on b.bookid=l.bookid 
-        join appuser u on l.userid=u.userid
-        left join genre g on g.bookid=b.bookid
+select b.title, b.author, b.language, b.imageurl, l.condition, au.username, au.city, au.neighborhood, g.genre
+from book b join librarybook lb on b.bookid=lb.bookid 
+        join library l on l.inventoryid=lb.inventoryid 
+        join appuser au on l.userid=au.userid 
+        left join genre g on g.bookid=b.bookid  
 where lower(b.title) like ('%search%') or lower(b.author) like ('%search%') or lower(g.genre) like ('%search%')
-order by u.city, u.neighborhood;
+order by au.city, au.neighborhood;
 
 }}}