ALZ6X8Up

1drop table if exists request;
2
3create table request
4(
5request_id int unsigned not null auto_increment primary key,
6created_date datetime not null
7)
8engine = innodb;
9
10insert into request (created_date) values (curdate()),(curdate()),(curdate()),(curdate());
11
12drop table if exists request_item;
13
14create table request_item
15(
16item_id int unsigned not null auto_increment primary key,
17request_id int unsigned not null,
18created_date datetime not null,
19key request_item_request_idx(request_id)
20)
21engine = innodb;
22
23insert into request_item (request_id, created_date) values 
24(1,curdate()),(1,curdate()),(2,curdate()),(2,curdate()), (3,curdate()), (3,curdate()), (4,curdate());
25
26select * from request;
27
28select * from request_item;
29
30select
31 r.*,
32 ri.*
33from
34 request r
35inner join request_item ri on r.request_id = ri.request_id
36where
37 r.request_id = 2;