编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE inaca (
	id int,
	numb varchar(255),
	alpha varchar(255),
	calpha varchar(255)
);
CREATE TABLE kiritsugu (
	pid int,
	numb varchar(255),
	beta varchar(255),
	cbeta varchar(255)
);
INSERT INTO kiritsugu VALUES (1, '35', 'profession', 'EXHAUSTED');
INSERT INTO kiritsugu VALUES (2, '55',  'walter white', 'PERPLEX');
INSERT INTO kiritsugu VALUES (3, '171',  'jesse pinkman', 'SUBORDINATE');
INSERT INTO kiritsugu VALUES (4, '4',  'gustavo fring', 'ASSOCIATE');
INSERT INTO kiritsugu VALUES (5, '79',  'drug', 'GOODS');
INSERT INTO kiritsugu VALUES (6, '109',  'jane', 'ZYWOO');
INSERT INTO kiritsugu VALUES (7, '66',  'wjqmachine', 'DEVICE');
INSERT INTO kiritsugu VALUES (8, '7900',  'ishowspeed', 'ART');
INSERT INTO kiritsugu VALUES (9, '10983',  'drug', 'J');
INSERT INTO kiritsugu VALUES (10, '3789',  'lbwnb', 'ZYWOO');
INSERT INTO inaca VALUES (101, '35', 'tomorin', 'BESIGN');
INSERT INTO inaca VALUES (102, '55',  'soyo', 'MUTUAL');
INSERT INTO inaca VALUES (103, '171',  'hachimi', 'CEASE');
INSERT INTO inaca VALUES (104, '3',  'sakiko', 'DEDUCE');
INSERT INTO inaca VALUES (105, '79',  'sumimi', 'CONFER');
INSERT INTO inaca VALUES (106, '109',  'ave mujica', 'TRIUMPH');
INSERT INTO inaca VALUES (107, '65',  'mygo!!!!!', 'DEVISE');
INSERT INTO inaca VALUES (108, '7900',  'sato', 'WEARY');
INSERT INTO inaca VALUES (109, '10983',  'sashi', 'JT');
INSERT INTO inaca VALUES (110, '3789',  'emiya', 'ZYWOO');

SELECT inaca.pid,inaca.numb,inaca.beta,kiritsugu.id,kiritsugu.numb,kiritsugu.alpha FROM inaca inner join kiritsugu on kiritsugu.numb=inaca.numb;