# How do I do lookups? **URL:** \ **Category:** CloverDX Platform\ **Created:** [December 28, 2011, 12:00am UTC](https://forum.cloverdx.com/t/how-do-i-do-lookups/992 "2011-12-28T00:00:00Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![sgehret](https://avatars.discourse-cdn.com/v4/letter/s/ac8455/32.png) [@sgehret](https://forum.cloverdx.com/u/sgehret)\ **Post date:** [December 28, 2011, 12:00am UTC](https://forum.cloverdx.com/t/how-do-i-do-lookups/992/1 "2011-12-28T00:00:00Z")
I have 2 tables in SQL Server that I must combine into 1 in Oracle. Simple example: Tab1 has col1, col2. Tab2 has col3, col4, col5. Tab2 is a lookup table. For every record in Tab1, I need to see if there is a record in Tab2 and get col4 and col5. The join is Tab1.col1 = Tab2.col3. The fields have different names. But I want my output record to be Tab1.col2, Tab2.col4 and Tab2.col5. I am trying with Joiners LookupJoin and DBJoin. But I don’t see anywhere to tell them that Tab1.col1 = Tab2.col3. Thanks, Scott ---
**Author:** ![dpavlis](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dpavlis](https://forum.cloverdx.com/u/dpavlis)\ **Post date:** [December 30, 2011, 3:25pm UTC](https://forum.cloverdx.com/t/how-do-i-do-lookups/992/2 "2011-12-30T15:25:49Z")
Your example leads to use of HashJoin _(probably better)_ or MergeJoin. It allows defining the “join” formula and also re-mapping two inputs onto single output record including renaming fields. See examples supplied with CloverETL Designer, one of them shows various joiners in action. Also, see Clover video tutorial, section [Joining data from multiple sources and Aggregating](http://www.cloveretl.com/documentation/quickstart/joining%5Fdata%5Ffrom%5Fmultiple%5Fsou.htm). If you really want to use lookups for your case, then look at [Lookups section](http://www.cloveretl.com/documentation/quickstart/lookups.htm) of Clover video tutorial.