Membandingkan isi dari 2 table di PostgreSQL

Published 19 Oct 2019 by A Fakhrurozi S

Bagaimana cara membandingkan 2 data table ?

SELECT
   NAME_COLUMN,
   'not in bar' AS note
FROM
   NAME_TABLE
EXCEPT
   SELECT
      NAME_COLUMN,
      'not in bar' AS note
   FROM NAME_TABLE

Referensi: http://www.postgresqltutorial.com/