title: Google spreadsheet "=QUERY" join() equivalent function?
body: <p>This question is concerning joining two databases in Google spreadsheet using =QUERY function</p>
  
  <p>I have a table like so in range A1:C3</p>
  
  <pre><code>a d g
  b e h
  c f i
  </code></pre>
  
  <p>I have another table</p>
  
  <pre><code>c j m
  a k n
  b l o
  </code></pre>
  
  <p>I want the final table to look like this</p>
  
  <pre><code>a d g k n
  b e h l o 
  c f i j m
  </code></pre>
  
  <p>I can do this by using a vlookup function pretty easily in cell D1 and paste it down and across, but my dataset is huge. I would need a whole page of vlookups and Google Spreadsheet tells I'm at my limit in complexities.</p>
  
  <p>I look at the Google's Query Language reference... there doesn't seem to be an type of "join" functions mentioned. You would think it would be an easy "join on A" type operation.</p>
  
  <p>Can anybody solves this without a vlookup?</p>