Help with condition

[Arcane]

Hi Folks,

Looking for a condition to merge the following example.

Table A

ID
1
2
3
4
5
A
B
C

Table B

ID	ID Alias
7	A
8	B
9	C

Table A and Table B are joined (Join columns not illustrated here.)

Now, I would like to have a column with all numerics in one column(ID_Numeric)

Thanks in advance

[atcodedog05]

Happy to help : ) @Arcane 

Cheers and have a nice day!