MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Orders
(
       OrderID integer,
       Reference varchar(30)
);

CREATE TABLE OrderStatus
(
       OrderStatusID integer,
       OrderID integer,
       OrderType varchar(3),
       CompletionDate varchar(30)
);
INSERT INTO Orders (OrderID, Reference)
VALUES (1, 'Xdsfsf'), (2, '43543543');

     
INSERT INTO OrderStatus (OrderStatusID, OrderID, OrderType, CompletionDate)
VALUES (1, 1, 'XX', '10-10-2018'), (2, 2, 'YY', '10-10-2019'), (3, 1, 'XX', '10-10-2019')
SELECT * FROM Orders;

SELECT * FROM OrderStatus;


OrderID
Reference


1
Xdsfsf

2
43543543




OrderStatusID
OrderID
OrderType
CompletionDate


1
1
XX
10-10-2018

2
2
YY
10-10-2019

3
1
XX
10-10-2019