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  | 
                             
                            
                                    | 
                                         sqlwired 
                                        Starting Member 
                                         
                                        
                                        1 Post  | 
                                        
                                        
                                            
                                            
                                             Posted - 2013-03-28 : 18:46:13
                                            
  | 
                                             
                                            
                                            | Hi! I need help! Here is the problem...I have two tables in database. First is tblA and it contains fields(ID, date, description and amountin) second one is tblB it contains fields (IDb, date, description, amountout) primary keys are IDs from both tables. What I need is to create some kind of report which will display next fields from both tables orderno, description, amountin and amountout depending on date which I select...also it should save that report only if some change has been made. example report 1 on 20.03.2012. I realy hope that you understand what I need.. | 
                                             
                                         
                                     | 
                             
       
                            
                       
                          
                            
                                    | 
                                     TG 
                                    Master Smack Fu Yak Hacker 
                                     
                                    
                                    6065 Posts  | 
                                    
                                      
                                     | 
                                   
                            
                       
                          
                            
                                    | 
                                     visakh16 
                                    Very Important crosS Applying yaK Herder 
                                     
                                    
                                    52326 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2013-03-29 : 14:06:27
                                          
  | 
                                         
                                        
                                          | your table structure and output doesnt match. As suggested by TG please pot required info if you need any further help------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |