Postgresql returning repeating data on multiple join

user619

1^#

user619 Published in April 26, 2018, 1:44 pm

I can't figure out why my output is duplicating, but I'm sure it is incorrect joins. I'm new to SQL in general, so this may be an inefficent query.

SELECT a.id, a.number, a.number2, b.id, b.number3, b.number4, c.id, c.score, (a.number - b.number3) as a_b_difference, (a.number2 - b.number4) as a_b_difference3 FROM file a
INNER JOIN file b on a.id = b.id
INNER JOIN file c on a.id = c.id

I want to subtract the two fields and combine all three files on the id. However, my result populates with repeating data.

This is a sample of what I am getting:

Sql Postgresql

• What is the difference between “INNER JOIN” and “OUTER JOIN”?
• PostgreSQL “DESCRIBE TABLE”
• Show tables in PostgreSQL
• Creating a copy of a database in PostgreSQL
• Save PL/pgSQL output from PostgreSQL to a CSV file
• Drop all tables in PostgreSQL?
• What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?
• How to exit from PostgreSQL command line utility: psql
• CDbCommand - Three Tables Join and IN Clause Syntax
• Oracle: Having join or simple from/where clause has no affect on performance?

Return

You need to login account before you can post.

Postgresql returning repeating data on multiple join

Related posts