Execute Query for Join on databse

[Tapiwa (TapiwaMakamure)]

Hie guys.
I want to use join using execute query activity but its getting nothing. But when i run the same query on my sql database there are results.
My query is
select customer.name,customer.idcus, order.type from order inner join customer on order.id = customer.idcus;

[radhagangwani90 (Radha)]

May I know how are you writing it in UiPath?

[Tapiwa (TapiwaMakamure)]

@Tapiwa

select customer.name,customer.idcus, order.type from order inner join customer on order.id = customer.idcus;

used activity execute query. Then wrote the sql query as “select customer.name,customer.idcus, order.type from order inner join customer on order.id = customer.idcus”