Changes between Version 4 and Version 5 of ImportantUseCase3

Timestamp:

01/21/22 22:20:16 (2 years ago)

Author:

191215

Comment:

--

ImportantUseCase3

@@ -35 +35 @@
 
 {{{
+select u.full_name, u.email 
+        from artists a
+        join managers m on a.manager_id = m.user_id 
+        join users u on u.id = m.user_id 
+        where 
+                a.user_id = (select u.id from users u
+                        where u.email = 'test_artist@mail.com')
 }}}