SQL$/$Access

Tables on Screenshot.

Display the result of inner join between $u1$ and $u2,$ where the join condition is

$\text{'}$u$1.$uid $=$ u$2.$uid'.

$-$Demonstrate a left outer join of u$1$ with itself using the condition uid $=$ uid.

$-$Demonstrate a right outer join of u$1$ with itself using the condition uid $=$ uid.

$-$Demonstrate a left outer join of u$1$ with u$2,$ with the join condition being u$1.$uid $=$u$2.$uid.

$-$Demonstrate a right outer join of u$1$ with u$2,$ with the join condition being u$1.$uid $=$u$2.$uid.