Should be a simple question but I've never done it before and would love a little help getting started. I have a demographic table with about 30 fields. On a daily basis, I get a new file with potentially updated data. Whats the simpliest way to do a comparison to see if any of the 30 field have changed? I know I could do a series of WHERE newtable.field1<>existingtables.field1 but that has to be an easier way.
Thanks in advance!!