MySQL 8.0

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

CREATE TABLE table1(
id INT,
postID int,
status int,
`number` int,
userID int,
active int  );

insert into table1 values
(1,1,100,100,3,1),
(2,7,50,25,5,1),
(3,3,75,50,3,1);


CREATE TABLE table2(
postID int,
reference int,
joint_date int,
userID int,
remove int  );

insert into table2 values
(1,100,100,3,1),
(2,50,25,5,1),
(3,50,50,3,0);



select * from table1;
select * from table2;


id
postID
status
number
userID
active


1
1
100
100
3
1

2
7
50
25
5
1

3
3
75
50
3
1




postID
reference
joint_date
userID
remove


1
100
100
3
1

2
50
25
5
1

3
50
50
3
0


SELECT t1.postID, 
       t1.status,
       t1.`number`, 
       t2.reference, 
       t2.joint_date
FROM table1 t1 
INNER JOIN table2 t2  ON t1.postID=t2.postID
WHERE t1.active=1 
AND t1.userID=3
ORDER BY t1.postID ASC;


postID
status
number
reference
joint_date


1
100
100
100
100

3
75
50
50
50