Advanced Search

Return to Snippet

Revision: 4980
at February 1, 2008 04:26 by zingo
Initial Code 
SELECT 'tabelle1' Tabelle, a.* FROM (
SELECT * FROM tabelle1
MINUS
SELECT * FROM tabelle2
) a
UNION
SELECT 'tabelle2' Tabelle, b.* FROM (
SELECT * FROM tabelle2
MINUS
SELECT * FROM tabelle1
) b
Initial URL 
http://blog.256bit.org/archives/441-Den-Unterschied-zwischen-2-Tabellen-herausfinden.html
Initial Description 









Initial Title





Differences between two Tables









Initial Tags





mysql, sql









Initial Language





SQL