psql returning same result multiple times

Question

I am trying to get results from psql with this code:

SELECT * 
FROM zoho, high_income 
WHERE zoho.zip = high_income.zip;

It retrieves that data that I want, however, it prints every result three times. For example:

John Doe 77808 94912
John Doe 77808 94912
John Doe 77808 94912
Jane Doe 88493 94110
Jane Doe 88493 94110
Jane Doe 88493 94110

I don't have three copies of each record in either table.

Possible duplicate of [How to select unique records by SQL](http://stackoverflow.com/questions/1641718/how-to-select-unique-records-by-sql) — Holger Just, Jun 24 '16 at 23:19

score 0 · Accepted Answer · answered Jun 25 '16 at 02:05

0

try this :

SELECT DISTINCT *
FROM zoho, high_income 
WHERE zoho.zip = high_income.zip;

answered Jun 25 '16 at 02:05

Merve Sahin

1 Answers1