Same column name different data on local table and filling it with one select

[neonebu]

Hello, i have 2 areas on my local table. When i use select command from other tables, i require same column but different data according to different condition.
Example table: A | A
1 | 2
3 | 4

Can this be done with same select* ?

Any help would be appreciated. Thank you

[FredericGirod]

Did you try ?

with

SELECT w6~maktx as maktx, w7~maktx as baz_maktx  

[neonebu]

frdric.girod it is working thank you!!