Intern — Middle
What is the result of an SQL query with a JOIN operator
livecode
Task condition
Determine which values will be returned by the query:
Select UserName From
dbo.Users u
JOIN dbo.UserActivity ua on
ua.UserName = u.UserName
Given two tables.
Table Users:
UserName Email
xxx xxx@mail.ru
yyy yyy@mail.ru
zzz zzz@mail.ru
Table UserActivity:
UserName ActivityCount Date
xxx 5 10.01.2024
yyy 8 10.01.2024
zzz 12 10.01.2024
ooo 19 11.02.2024
xxx 4 11.02.2024
Which rows will be in the resulting set?