'Performing table join in pgadmin

I am trying to join the task table to wr2_descending but getting confused. The id column seems to be used for joining them. However, there is quad_id in task table, and 2 different id's gid and pr_id in wr2_descending and am wondering which id to equate the quad_id from the task table to the id in wr2_descending. The wrspr and pr columns from the wr2_descending also looks so similar to me and includes the same values.

enter image description here

Code:

SELECT
  task_table.quad_id 
  wrs2_descending.gid
FROM task_table
JOIN wrs2_descending ON task_table.quad_id=wrs2_descending.gid
pgadmin


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions