Please could you help me in below query I need to dispay column from other table.
tw.account_id as ACCT_ID,
left join booked_tbl bod
on tw.oidd = bod.oidd
and tw.pid = bod.pid
left join sm_dmd_tbl smdo
on tw.oidd = smdo.oidd
and tw.pid = smdo.pid
group by tw.account_id , tw.oidd );
I need to display one more column brkup in above query.in the below format
" gp_code|amt " based on id.this clumn values is fom different table.
my other query is :
select substr(replace(sys_connect_by_path(name,'/'),'/',','),2) brkup
from ( select aw_transaction_id, GROUPCODE||'|'||amt name,
row_number() over(partition by transid order by GROUPCODE) rn
where connect_by_isleaf = 1
connect by prior transid = transid
and prior rn = rn-1
start with rn = 1 ;
I want as a output:
ACCT_ID tw.oidd new_value brkup (this value is based on concatenation of gpcode)
How can I show this dispaly this type of output?
Thanks in advanced.