Posts by Professador • 11 points
1 post
-
1
votes1
answer1291
viewsA: Compare data from a table in Postgresql
If the comparison is all columns: SELECT sc.*, gc.* FROM geral.cargo gc INNER JOIN serv.cargo sc ON gc.* <> sc.* AND gc.id=sc.id; The clause ON accepts several comparisons.…