Hi,
sometimes one has to have the feeling, that somebody wants to help to
get it done better! :) I think I got it:
select a.id, a.value from test as a left join test as b on a.id=b.id
where a.value <> b.value group by a.id,a.value;
It´s good to check logtables!
Of course I would appreciate suggestions of doing this better!
Thanks for your help!
Have a nice thread,
Peter
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php