I am trying to write a query that join to a `TableA` another `TableB` if `TableA.Column1` contains `numeric` values and `Join` to `TableA` another `TableC` if `TableA.Column1` contains `varchar` values.

Is there a way to write such a query?