Select Code to Download

Example file

table 1  table 2  key 1  key 2
...
apple    cat      unid1  unid3
bug      dog      unid2  unid4
apple    dog      unid1  unid4

Example 1:

[dmathis@wildman dmathis]$ ./script apple bug
...

apple a
join bug b on a.unid1 = b.unid2

Example 2:

[dmathis@wildman dmathis]$ ./script apple dog
...
Option 2:
apple a
join dog d on a.unid1 = d.unid4