Advanced Search

Differences between two Tables

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT 'tabelle1' Tabelle, a.* FROM (
  2. SELECT * FROM tabelle1
  3. MINUS
  4. SELECT * FROM tabelle2
  5. ) a
  6. UNION
  7. SELECT 'tabelle2' Tabelle, b.* FROM (
  8. SELECT * FROM tabelle2
  9. MINUS
  10. SELECT * FROM tabelle1
  11. ) b

URL: http://blog.256bit.org/archives/441-Den-Unterschied-zwischen-2-Tabellen-herausfinden.html

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.