Hi all,
I have a requirement in order to satisfy which i need a query of the type given below:
select a.name,b.address
from table1 b
left outer join (select name from table2 where id=(Prompt)) as a
on b.id=a.id
do any one know how this can be accomplished in MSTR
Thanks.
I have a requirement in order to satisfy which i need a query of the type given below:
select a.name,b.address
from table1 b
left outer join (select name from table2 where id=(Prompt)) as a
on b.id=a.id
do any one know how this can be accomplished in MSTR
Thanks.