PtETwMvV

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