I have three tables a b c and d

I have to join a b and d

And join a c and d

Which I get two results and join both of them using column present in a

What are the best ways to do basically doing joins of tables seprate and later join both results

Iused correlated subquery in select and join in where clause to sepreate joins