select obj.object_name, als.alias_id from orf.hsp_object obj
LEFT JOIN
(select * from orf.hsp_alias where aliastbl_id = '14') als ON als.member_id=obj.object_id
where obj.object_type = '50';
I want to use the internal query i.e. select * from orf.hsp_alias where aliastbl_id = '14' as variable.. something like below
Define select * from orf.hsp_alias where aliastbl_id = '14' as als
select obj.object_name, als.alias_id from orf.hsp_object obj
LEFT JOIN
als ON als.member_id=obj.object_id
where obj.object_type = '50';
What should be the correct syntax for above? Thanks.