Hi Evan, 1) Which database are you using? 2) Why do you need to store the differences?
Loving SQL, Jason ----- Evan wrote: Hey Guys I have a bit of a SQL problem and I need some advice. I have a table that is used to record settings for a device. After the settings are recorded the device is used. The operator may change the settings after that first round and re save the settings then run the device again and get a different result. I have to generate a report that displays the differences in the settings between runs. Any ideas on comparing 2 different rows of data in the same table, and then store those differences in another table. Evan _______________________________________________ clug-talk mailing list [EMAIL PROTECTED] http://clug.ca/mailman/listinfo/clug-talk_clug.ca
