CREATE TABLE e1(
id INT,
price INT
);
INSERT INTO e1(id, price) VALUES (1, 50);
INSERT INTO e1(id, price) VALUES (1, 30);
INSERT INTO e1(id, price) VALUES (2, 50);
INSERT INTO e1(id, price) VALUES (3, 80);
DROP TABLE e2;
CREATE TABLE e2(
id INT,
name VARCHAR(50)
);
INSERT INTO e2(id, name) VALUES (1, '第一');
INSERT INTO e2(id, name) VALUES (2, '第二');
INSERT INTO e2(id, name) VALUES (3, '第三');
SELECT * FROM e1
INNER JOIN e2
ON e2.id = e1.id
就是e1如果有2个记录,e2有1个记录的话,INNER JOIN还是会把2个记录都检索出来
记住:联结显示最多MAx(m,n)的那一个列呀,因为有ON
select * from a,b则显示笛卡尔积(m*n)行记录,之后我再根据条件过滤掉一部分