# Stream lookup query

**URL:** <https://community.automationedge.com/t/stream-lookup-query/9995>\
**Category:** Process Studio\
**Tags:** rpa\
**Created:** [June 29, 2023, 12:05pm UTC](https://community.automationedge.com/t/stream-lookup-query/9995 "2023-06-29T12:05:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![samach008](https://avatars.discourse-cdn.com/v4/letter/s/8dc957/32.png) [@samach008](https://community.automationedge.com/u/samach008)\
**Post date:** [June 29, 2023, 12:05pm UTC](https://community.automationedge.com/t/stream-lookup-query/9995/1 "2023-06-29T12:05:39Z")

</div>

Is stream lookup left outer join, right outer join or both.

---

<div class="post-metadata">

**Author:** ![Jane](https://avatars.discourse-cdn.com/v4/letter/j/ecb155/32.png) [@Jane](https://community.automationedge.com/u/Jane)\
**Post date:** [July 12, 2023, 5:09am UTC](https://community.automationedge.com/t/stream-lookup-query/9995/2 "2023-07-12T05:09:52Z")

</div>

Hi! Satyam,

The Stream Lookup step looks up values based on Key field value. So it does not have the options for left outer join, right outer join or both.