Attempts

Start Yideo

$1$ attempt

Suppose there are two tables, A and B$.$ What would the following code output?

SELECT $*$ from A RIGHT JOIN B on$.$A$.$orderid $=$ B$.$orderid;

Only the records from table A where tables A and B have the same orderid.

Only the records from table B where tables A and B have the same orderid.

Grading

Maxim

Description

Please respect a

test by yourself.

option. The exam

much!

The complete set of records from table A$,$ along with the matching records $($depending on the availability$)$ from table $B$ where tables A and B have the same orderid.

The complete set of records from table $B,$ along with the

$($D$)$ matching records $($depending on the availability$)$ from table A where tables A and B have the same orderid.

Last saved $7$:$04$:$16$ PM