Changes between Version 1 and Version 2 of UseCase16

Timestamp:

09/19/26 17:11:22 (4 days ago)

Author:

236021

Comment:

--

UseCase16

@@ -42 +42 @@
 SELECT
   lt.technician_id,
-  lt.user_id,
-  lt.certification
+  lt.username,
+  lt.name,
+  lt.lastname,
+  lt.email
 FROM lab_technician lt
-WHERE lt.user_id = (SELECT user_id FROM users WHERE username = 'darko.milosev');
+JOIN users u ON u.lab_technician_id = lt.technician_id
+WHERE u.username = 'darko.milosev';
 }}}