Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

neonebu
Explorer
0 Kudos
358

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

2 REPLIES 2

FredericGirod
Active Contributor
315

Did you try ?

with

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

neonebu
Explorer
0 Kudos
315

frdric.girod it is working thank you!!