I Developed 2 Table

1)FriendTable

Code:
 CREATE TABLE `friendtable` (            
               `username` varchar(50) default NULL,  
               `fusername` varchar(50) default NULL  
             ) ENGINE=InnoDB DEFAULT CHARSET=latin1
2)Msg Table

Code:
 CREATE TABLE `msg` (                                      
          `msg` varchar(50) default NULL,                         
          `username` varchar(50) default NULL,                    
          `dt` date default NULL,                                 
          `id` int(50) unsigned NOT NULL auto_increment,          
          PRIMARY KEY  (`id`)                                     
        ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1
i need to get all the messages send by the fusername who is friend of username in friend table and messages send by username

can anybody help me??