SQL development history
SQL statement classification
join clause—inner join
Clause—left outer join
join clause—right outer join
join clause—full join
join clause - cross join
Update table using join
Use join to optimize subqueries
Use join to optimize aggregate subqueries
How to implement group selection data
1. How to use join statement correctly 2. How to implement group selection data
