Mich informieren, sobald neue Inhalte hinzugefügt werden

Forum: SQL | Thema: SQL Query which shows differences between 2 tables | Von: G. Guest ( 12.10.2005 09:08) Hi all I have a question, I have 2 tables: Table 1: hannes olaf Table 2: hannes werner Now I want to see what are the differences between those 2 tables. I think of a new table which looks like: Table 1 Table 2 olaf - - werner So olaf is in table 1 but not in table 2 and werner is in table 2 but not in table 1 and hannes is in both tables so no need to show him Can anyone please help me on this ? Thank you very much Hannes Betreff Von Datum Re: SQL Query which shows differences between 2 tables Hallo Hannes, do you like to write German ?<br>Sorry i have an question. In Table1 how many Columns do you have?? Like Table1 <br>Firstname Secondname<br>hannes Olaf<br>or... Thomas Scherner 12.10.2005 09:30 Re: SQL Query which shows differences between 2... Hi,<br>try something like this:<br><br>select name as Table1, '-' as Table2 from table1<br>where name not in (select name from table2)<br>union<br>select '-', name from table2 <br>where name not in (select name... Jens Buthe 12.10.2005 09:59 Re: SQL Query which shows differences between 2... Yihaaaaaa, Super spitze wahnsinn. <br>vielen Dank es geht<br> G. Guest 12.10.2005 10:55 Re: SQL Query which shows differences between 2 tables Okay of course now i want additional information ;-)<br><br>I have a table:<br>NAME|EMAIL|TEXT<br>hans|hans@web.de|TEXT 1<br>hans|hans@web.de|TEXT 2<br>werner|werner@web.de|TEXT A<br><br>I save the records of the... G. Guest 12.10.2005 11:26 Re: SQL Query which shows differences between 2... Hallo Hannes,<br>sorry i don't understand. But do you have an Timestamp for the entries? Thomas Scherner 12.10.2005 12:34 Re: SQL Query which shows differences between 2... no i dont have a timestamp, i just have the data.<br> G. Guest 12.10.2005 12:59 Re: SQL Query which shows differences between... So it is very hard. Then you list al changes but you don't see where they are taken. Do you want this ???<br><br>select * from table a, table b<br>where a.name=b.name<br>and a.web<>b.web<br>or ......<br><br>so you... Thomas Scherner 12.10.2005 13:02 Antworten Vorsicht bei der Eingabe: Die Zeichen ' oder -- sind nicht erlaubt!  Betreff:  Nachricht: Den Beitrag finden Sie nun unter: http://beta.devtrain.de/foren Die Benutzerdaten und Foreninhalte von beta.devtrain.de und www.devtrain.de sind die selben. Sie können sich dort sogar per RSS über neue Inhalte informieren lassen. Bei Problemen bitte direkt Mail an asp [AT] ppedv.de.  Signatur: