Skip to content

Tag: except

Using EXCEPT clause in PostgreSQL

I am trying to use the EXCEPT clause to retrieve data from table. I want to get all the rows from table1 except the one’s that exist in table2. As far I understand, the following would not work: The only way I can use EXCEPT seems to be to select from the same tables or select columns that have the