Question: which one please? The correct query to Join the (Friendship and RegularUser) tables: Answers: Select R.Email, HomeTown, Relationship From Friendship as F INNER JOIN RegularUser
The correct query to Join the (Friendship and RegularUser) tables: Answers: Select R.Email, HomeTown, Relationship From Friendship as F INNER JOIN RegularUser as R ON F.Email = R.Email; Select R.Email, Fname, LName, HomeTown, Relationship From Friendship as F INNER JOIN RegularUser as R ON F.Email = R.Email INNER JOIN User as U ON U.Email = R.Email; Select R.Email, Fname, LName, HomeTown, Relationship From Friendship as F INNER JOIN User as U ON U.Email = R.Email; Select R.Email, Fname, LName, HomeTown, Relationship From RegularUser as R INNER JOIN User as U ON U.Email = R.Email
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
