| Forum: SQL |
Thema:
Re: SQL Query which shows differences between 2 tables |
Von:
G. Guest (
12.10.2005 11:26) |
Okay of course now i want additional information ;-)
I have a table:
NAME|EMAIL|TEXT
hans|hans@web.de|TEXT 1
hans|hans@web.de|TEXT 2
werner|werner@web.de|TEXT A
I save the records of the table everyday, now i want to see what has changed between the days.
So e.g. on the next day the table looks like this
NAME|EMAIL|TEXT
hans|hans@web.de|TEXT 1
werner|werner@web.de|TEXT A
olaf|olaf@web.de|TEXT X
So the result I am looking for is:
OLD/NEW
hans|hans@web.de|TEXT 2/-
-/olaf|olaf@web.de|TEXT X
This tells me hans has lost TEXT 2, and olaf is new...
Uuuuaaah - how does that work ?
Thanx again
Hannes
| Betreff |
Von |
Datum |
|
|
|
|
Thomas
Scherner
|
12.10.2005 12:34 |
|
|
|
|
G.
Guest
|
12.10.2005 12:59 |
|
|
  |
Re: SQL Query which shows differences between 2...
| 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!
