visual foxpro join one column of the table to another table
<p>I have two visual foxpro tables like this:</p>

<pre><code>table 1:
Client name    age
Jason          65
Tom            44
Phil           30

table 2: (exactly same client name)
Client name    salary
Jason          100
Tom            200
Phil           300
</code></pre>

<p>I want to join the two tables like this:</p>

<pre><code>Client name    age  salary
Jason          65   100
Tom            44   200
Phil           30   300
</code></pre>

<p>Can anyone tell me the syntax for that? Thanks!</p>