# Look up join

**URL:** <https://forum.cloverdx.com/t/look-up-join/216>\
**Category:** CloverDX Platform\
**Created:** [September 5, 2007, 12:00am UTC](https://forum.cloverdx.com/t/look-up-join/216 "2007-09-05T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![srinu](https://avatars.discourse-cdn.com/v4/letter/s/f475e1/32.png) [@srinu](https://forum.cloverdx.com/u/srinu)\
**Post date:** [September 5, 2007, 12:00am UTC](https://forum.cloverdx.com/t/look-up-join/216/1 "2007-09-05T00:00:00Z")

</div>

hi

I was trying to use look up join compenent to join two tables

stg\_loan—\>main table

customer—\>lookup table

i need to select 4 columns from stg\_loan and 3 columns from customer based on loan\_id.

but how should i select fields coming from lookup table into output stream as there is no provision of mapping look up table fields to output stream

and also exlpain in wat scenario we use left outer join and full outer join

Please some body help me on this.

Thanks in advance

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [September 6, 2007, 1:06pm UTC](https://forum.cloverdx.com/t/look-up-join/216/2 "2007-09-06T13:06:22Z")

</div>

Hi,  
in LookupJoin component data from lookup table as treated as 1st input (0th input is data from input port). See example [http://wiki.clovergui.net/examples/graphLookupJoin.grf](http://wiki.clovergui.net/examples/graphLookupJoin.grf)

---

<div class="post-metadata">

**Author:** ![srinu](https://avatars.discourse-cdn.com/v4/letter/s/f475e1/32.png) [@srinu](https://forum.cloverdx.com/u/srinu)\
**Post date:** [September 18, 2007, 6:01am UTC](https://forum.cloverdx.com/t/look-up-join/216/3 "2007-09-18T06:01:14Z")

</div>

hi ,

i wrote a java progarm in the transfrom class and now it is running fine .

thanks