Changes between Version 13 and Version 14 of UseCase4

Timestamp:

01/21/22 20:41:26 (3 years ago)

Author:

193026

Comment:

--

UseCase4

@@ -93 +93 @@
         r.reviewer_name,
         r.reviewer_verified,
-        review.review_title,
-        review.review_text,
-        review.review_stars
-from
-        review
-join reviewer r 
-on
-        review.reviewer_id = r.reviewer_id
+        rv.review_title,
+        rv.review_text,
+        rv.review_stars,
+        rv.address_id
+from review rv
+join reviewer r on
+        rv.reviewer_id = r.reviewer_id
 where
-        review.business_id = 4;
+        rv.business_id = 4
 }}}