Database collation--Advanced query

# Notes
--Notes

--Advanced query
--Connection Query
SELECT t1. ' Name ', T2. Brand_Name from brand T2,car T1--Cartesian product
WHERE T2. Brand_Code = t1. Brand
--Multi-table connection query
SELECT t1. ' Name ', T2. Brand_name,t3.prod_name
From car t1
Left JOIN brand T2 on T1. Brand = t2. Brand_Code
Left joins Productor T3 on T2. Prod_code = T3. Prod_code
--The number of union query fields must be the same
SELECT ' Name ', price from car
UNION
SELECT Brand_name,brand_memo from Brand
--Sub-query
SELECT * FROM car
WHERE Car.brand in
(SELECT Brand_Code from Brand WHERE prod_code = ' p001 ')

Database collation--Advanced query