Need a Query Help

[binumathew1988]

I Developed 2 Table

1)FriendTable

 CREATE TABLE `friendtable` (            
               `username` varchar(50) default NULL,  
               `fusername` varchar(50) default NULL  
             ) ENGINE=InnoDB DEFAULT CHARSET=latin1

2)Msg Table

 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??

[r937]

please provide sample data, preferably by dumping some rows from each table

then show us what the query should return based on your sample data

[binumathew1988]

Friend Table Having Data

username fusername
---------- ---------
binumathew jesvin
binumathew ddd

Msg Table

msg username dt id
---------- ---------- ---------- ------
sdsdsd binumathew 0000-00-00 11
sdsdsddsds binumathew (NULL) 12
dddd jesvin 0000-00-00 13
ddddd ddd 0000-00-00 14

I need a result like this

msg username dt id
---------- ---------- ---------- ------
sdsdsd binumathew 0000-00-00 11
sdsdsddsds binumathew (NULL) 12
dddd jesvin 0000-00-00 13
ddddd ddd 0000-00-00 14

[r937]

I need a result like this

see, that's why i was asking for sample data, so i can figure out what query you need

for the sample data you provided, and the result you want, use this --

SELECT msg, username, dt, id FROM msg