#基本连接
select * FROM aa,cc WHERE aa.id =cc.s_id;
#内连接
select * from aa INNER JOIN cc WHERE aa.id =cc.s_id;
#左连接
select * from aa LEFT JOIN cc ON aa.id =cc.s_id;
#右链接
SELECT * FROM aa RIGHT JOIN cc ON aa.id =cc.s_id;
#硬链接
SELECT * FROM aa UNION SELECT *FROM cc;
#临时表
SELECT * FROM aa,cc WHERE aa.id =cc.s_id;
SELECT NAME,score FROM (SELECT * FROM aa,cc WHERE aa.id =cc.s_id)a WHERE a.name ='zhangsan';
#嵌套
SELECT score FROM cc WHERE s_id =(SELECT id FROM aa WHERE NAME ='zhangsan');
#嵌套in
SELECT score FROM cc WHERE s_id in (SELECT id FROM aa WHERE NAME ='zhangsan');