Certifications & Credly badges:
Syed Saif ur has no Certifications & Credly badges yet.
Global Masters badges:
Syed Saif ur has no Global Masters badges yet.
Followers:
Syed Saif ur has no followers yet.
Following:
Syed Saif ur has not followed anybody yet.
In my opinion, the result can be achieved using a join:
SELECT column1, column2, column 3
FROM table
join table2 on
table.column1 = table2.c1
and
table.column2 = table2.c2