ferences Mailings Review View sty 1. When Must you qualify names in MysQL comman
ID: 3775412 • Letter: F
Question
ferences Mailings Review View sty 1. When Must you qualify names in MysQL commands? How do you do so? 2- what is a nested subauery? In which order does MySQL evaluate nested subaueties? 3 How do you join a table to itself in MySQL? 4- What does it mean for two tables to be union compatible? 5. How do you use the ANY operator with a subauen? 6 which rows are included in a left outer join? What clause can you use to perform a left outer join in Mysat? 7. What is the formal name for the product of two tables? How do you form a product in MySQL?Explanation / Answer
1) It could be possible that the different tables from which we are fetching data might have same colum name hence in order to avoid confusion we must qualify the colum names.
2) Nested SubQuery : Its a query within another query and we embedd it in where clause of main query like
Select * from tablename where(Select colum from secondtablename)
3) By using two different aliases for the same table ina single SQL command, you can join a table to itself.
Select * from tablename alias1 INNER JOIN tablename alias2
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.