txadYeFH

1-- borrowed from https://stackoverflow.com/q/7745609/808921
2
3CREATE TABLE IF NOT EXISTS `p1` (
4  `num_p` int(2) unsigned NOT NULL,
5  `nome` varchar(4) NOT NULL,
6  `nivel` int(2) unsigned NOT NULL,
7  `idade` int(2) unsigned NOT NULL,
8  PRIMARY KEY (`num_p`)
9) DEFAULT CHARSET=utf8;
10INSERT INTO `p1`
11  (`num_p`, `nome`, `nivel`, `idade`) VALUES
12  ('22', 'Joao', '7', '45'),
13  ('31', 'Lais', '8', '15'),
14  ('58', 'Rafa', '10', '35');
15  
16CREATE TABLE IF NOT EXISTS `r1` (
17  `num_p` int(2) unsigned NOT NULL,
18  `num` int(2) unsigned NOT NULL,
19  `data` varchar(8) NOT NULL,
20  PRIMARY KEY (`num_p`)
21) DEFAULT CHARSET=utf8;
22INSERT INTO `r1`
23  (`num_p`, `num`, `data`) VALUES
24  ('22', '101', '10/10/17'),
25  ('58', '103', '15/07/18');
26  
27CREATE TABLE IF NOT EXISTS `p2` (
28  `num_p` int(2) unsigned NOT NULL,
29  `nome` varchar(4) NOT NULL,
30  `nivel` int(2) unsigned NOT NULL,
31  `idade` int(2) unsigned NOT NULL,
32  PRIMARY KEY (`num_p`)
33) DEFAULT CHARSET=utf8;
34INSERT INTO `p2`
35  (`num_p`, `nome`, `nivel`, `idade`) VALUES
36  ('22', 'Zeca', '9', '35'),
37  ('58', 'Rafa', '10', '35');
38 
39-- ================================
40
41/*SELECT nome, data
42FROM p1, r1
43WHERE p1.num_p = r1.num_p*/
44
45(SELECT *
46FROM p1)
47union
48(SELECT *
49 FROM p2)