How to use except but excluding a column from the except operator comparison -psql? I want to compare two sets of columns but exclude one column from the comparison as it will never be in the second table and I need it on my result.
So, explaining:

columns for both tables: 


ID (unique value, so I do not want to compare)
amount
email
date


What I want to achieve:
Get all transactions from table 1 that has the exact same values on amount, email and date. I also want the ID to be in the final result set, but if I compare using the except clause, I will have 0 results at my query.

code:

Select /*ignoreAtComparison*/ t1.ID, t1.amount, t1.email, t1.date from t1

except

Select /*ignoreAtComparison*/ t2.ID, t2.amount, t2.email, t2.date from t2 ;


How can I do this?
except can be re-written as not exists query:

select t1.id, t1.amount, t1.email, t1.date
from t1
where not exists (select 1 
                  from t2
                  where t2.amount = t1.amount
                    and t2.email = t1.email
                    and t2.date = t1.date);


But your statement seems to indicate you do not actually want except but something entirely different.