Question

Employee rapie
ID
Name
Errazuriz
Salary
64000
100
101
89000
Fripp
Hunold
Dept_name
Administration
Marketing
Purchasing
Operations
Administration
102
86000
103
72000
Khoo
Ernst
104
100000
Department Table
Dept_id
AD-10
OP-24
Dept Mgr
Matthew
Adam
Payam
Shanta
Kevin
Dept_name Credits
Administration 5
Operations 4.
HR
3
Purchasing 2
Marketing 3
HR-33
PR-52
MK-01
For the above schema, how many records will be returned if you run the below quer
SELECT FROM employee
LEFT JOIN department USING (Dept_name)
union
SELECT* FROM employee
RIGHT JOIN department USING
(Dept_name)​

Answer 1

Answer:

what is this???????.........