Databases
StackOverflow2013
Postsdbo
POjoin two query using SQL
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POjoin two query using SQL
    primarykey
    data
    text
    <pre><code>SELECT test2.user_id,myTable1.myCol1 FROM testingtable2 test2 LATERAL VIEW explode(test2.purchased_item.product_id) myTable1 AS myCol1; </code></pre> <p>I am getting the below output result using the above query.</p> <pre><code> USER_ID | myCol1 -------------+--------------- 1015826235 220003038067 1015826235 300003861266 1015826235 140002997245 1015826235 200002448035 </code></pre> <p>If you compare the above output from the query with the below <code>Table2</code> data, then the last line from <code>Table2</code> data is missing in the above query output.</p> <p>And this is the second Table2.</p> <pre><code> BUYER_ID | ITEM_ID | CREATED_TIME -------------+--------------------+-------------------------- 1015826235 220003038067 2012-06-21 07:57:39 1015826235 300003861266 2012-06-21 21:11:12 1015826235 140002997245 2012-06-14 20:10:16 1015826235 200002448035 2012-06-08 22:02:17 *1015826235* *260003553381* *2002-01-30 23:12:18* </code></pre> <p>I need to print the last line basically using the <code>JOIN</code>, so the output should be like this after the <code>JOIN</code> between the query I wrote above and <code>Table2</code> data.</p> <pre><code>*1015826235* *260003553381* *2002-01-30 23:12:18* </code></pre> <p>So I need to do the <code>JOIN</code> between the above query I wrote and <code>Table2</code> data and get all the data that is not there in the output from the above query data. Any suggestion?</p> <p><strong>Just to add <code>myCol1</code> and <code>ITEM_ID</code> are same thing and <code>USER_ID</code> and <code>BUYER_ID</code> are same thing.</strong></p> <p>P.S- I need to use my above query to make the JOIN with Table2.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USarsenal
    1. USarsenal
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POjoin two query using SQL
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POjoin two query using SQL
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POjoin two query using SQL
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload