MYSQL

Question 1

MYsql Inner Join using a ven diagram

Answer 1

Imagine ven diagram of Table 1 and Table 2: results will be the overlap

Question 2

mysql inner join

Answer 2

SELECTt1., t2.FROMTable1 t1INNER JOINTable2 t2ONt1.ID=t2.ID

Question 3

mysql uses which: explicit or implicict syntax

Answer 3

explicit

Question 4

mysql three different type of outter joins

Answer 4

Left Outer Join

Right Outer Join

Full Outer Join*//mysql doesnt support

Question 5

does mysql support full outer join

Answer 5

false

Question 6

in mysql in a left/right ouuter join what keyword is optional

Answer 6

outer