boys表，girls表，id 同一个
inner join 内连接，也称为等值连接
隐式内连接：join、cross join
select * from boys , girls where boys.id = girls.id ;
select * from boys inner join girls where boys.id = girls.id ;
select * from boys inner join girls on boys.id = girls.id ;
select * from boys inner join girls using(id) ; 两个表中的字段名称都是id才可以使用using
select * from boys,girls ;
多表查询 member 、loan 表：
select member.Id , loan.Id , loan.Status from member , loan WHERE member.Id = loan.MemberID and member.Id = 185093;
原文：https://www.cnblogs.com/llqxixi/p/12403344.html
如果您也喜欢它,动动您的小指点个赞吧
602392714
清零编程群