-
To check if they are equal, isn't there a function that calculates a hash value of the whole row? (never used it)
For the output, how about:
REPLACE(tab1.col1, tab2.col1)||REPLACE(tab2.col1, tab1.col1) etc etc
gives you NULL if identical and something to work with if they are not (I'm assuming a quick & dirty is OK).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|