By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table1 (
data datetime2,
product int,
stock int
);
CREATE TABLE table2 (
data_start datetime2,
data_end datetime2,
product int
);
INSERT INTO table1 VALUES
('2023-05-10', 1, 3),
('2023-06-11', 1, 2),
('2023-06-12', 1, 2),
('2023-06-13', 1, 1),
('2023-06-14', 1, 1),
('2023-06-15', 1, 1);
INSERT INTO table2 VALUES
('2023-05-10', '2023-06-12', 1);
SELECT
*
FROM
table1
WHERE
table1.data BETWEEN (SELECT data_start FROM table2) AND (SELECT data_end FROM table2)
| data | product | stock |
|---|---|---|
| 2023-05-10 00:00:00.0000000 | 1 | 3 |
| 2023-06-11 00:00:00.0000000 | 1 | 2 |
| 2023-06-12 00:00:00.0000000 | 1 | 2 |