Using Freehand Joins Expressions

[Katie Sikorski]

I Have 5 tables I am trying to freehand join. The first a master table with all the well api numbers the others wells with tonma values. I want to join them together by api. When I try to do the join on multiple tables it says to use a freehand join. Then it is asking me for an expression does anyone know what I should use I am attaching an example below. I want all the wells in the Well List and only the wells that match in the others. Thanks for your help

 

 

 

 

Well API

ADM1_TONMA

ADM2_TONMA

ADM3_TONMA

ARMIDLAND_TONMA

 

 

4231736674

 

10.344

0.544

0.043

 

 

4231737484

 

10.344

0.544

0.043

 

 

4231738575

 

10.344

0.544

0.043

 

 

4231739391

 

10.344

0.544

0.043

 

 

4238339728

0.188

 

0.101

0.052

 

 

4238339730

0.188

 

0.101

0.052

 

 

4238336021

0.752

 

0.404

0.052

 

 

4238339729

0.188

 

0.101

0.052

[Fabian Duerr]

It depends on your data structure... If you want to keep all rows from your master table you should use a left outer join (master table = "left", table to join comes from "right"). If every table you join only holds one value for a Well API you can't do anything wrong. If it holds more than one value then you need to decide if you only want to merge for example the 1st value or all the values. If you merge all the values it will increase the rows in your master table.