Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | upendraStarting Member
 
 
                                        1 Post | 
                                            
                                            |  Posted - 2010-10-22 : 05:15:18 
 |  
                                            | ASSUME I HAVE 2 TABLES-----------------------                      ------------------TABLE a               =                       TABLE B-----------------------                      ------------------cOL1 | cOL2                                   CoL1  || CoL21       1                                     ----------------  2       2                                       1    || A3       3                                       2 ||  B----------                                      3   || c---------- |  |  
                                    | webfredMaster Smack Fu Yak Hacker
 
 
                                    8781 Posts | 
                                        
                                          |  Posted - 2010-10-22 : 05:23:25 
 |  
                                          | Have a look at your post and then think about if we can understand what you want... No, you're never too old to Yak'n'Roll if you're too young to die.
 |  
                                          |  |  |  
                                |  |  |  |