Clear Selection

Saved!

MySQL: Comma In From Clause

Choose the correct explanation of the next query:

SELECT $*$ FROM users, clients

Pick ONE option

Selects everything in the "users" table, then adds columns from the "clients" table.

If the "users" table exists, selects everything from there. Otherwise, queries the "clients" table as a fallback.

Selects everything in the "users" table, then assigns the "clients" alias.

Selects everything in the "users" table, then adds rows from the "clients" table.

Clear Selection

MySQL: Self Join

Select an expression that demonstrates a self join type.

Pick ONE option

SELECT $*$ FROM users users, users clients

SELECT $*$ FROM users SELF IOIN users AS clients