View Single Post
  #9 (permalink)  
Old March 22nd, 2007, 08:35 AM
pallone pallone is offline
Friend of Wrox
Points: 1,243, Level: 13
Points: 1,243, Level: 13 Points: 1,243, Level: 13 Points: 1,243, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2003
Location: , , United Kingdom.
Posts: 290
Thanks: 24
Thanked 0 Times in 0 Posts
Default

Hi Vijay G,

I have tried your code and I think it is going to help me a lot. After I run your code
I am doing a select - SELECT * FROM Compare ORDER BY IDTab2 - and I can compare the names, ids and values. The MaxValue is always coming from table1 which is right.

Could you please explain why you used the UNION clause. I have never used it before and am not sure in what context this should be used. Also, you are using the Datalength() function with '=' and '<>'. Can you elaborate a bit about why you are doing that.

Cheers,

CPALL
Reply With Quote