> Right, but when you write your script (or whatever) that cleans these > keys up and does the merge, you're where you started -- arbitrary > integer keys with no meaning. If you merge databases where the keys are > *supposed* to have meaning, you then have to mangle *real* data to make > them merge.
Also, there are plenty of circumstances besides the sale/merge one I mentioned which would require account # changes but not require changes to the synthetic keys. -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
