Can other table join depending on the value of the field?

I'm getting more and more table queries.

I'm leaving a question because I'm wondering if it's possible.

It could be a bit absurd (from what I know)

For example,

There is a table called A and a table called B It is joined by one field in a and idx in b.

Suppose you have a - b structure now, but you need other information, so you might need to join in the form a - b - c.

The problem is not only the a-b-c relationship, but also the case of joining another table like a-b-d

I wonder if I can make a type of field in b and divide it into 0, 1, 2, etc., and join another table according to the value.

I don't think it makes sense If that's possible, I think the relationship will be very simple because it's different depending on the type.

If possible, please give me a hint!