SELECT u.u_n, m.s_d, m.rd, m.t, m.imp
FROM `user` m, `message` u
WHERE m.r_id=02
AND u.u_id=m.s_id
AND m.is_j=0
AND m.is_t=0
ORDER BY m.s_d ASC

CREATE TABLE `user` (
  `u_id` tinyint(2) unsigned zerofill NOT NULL auto_increment,
  `user_name` varchar(10) binary NOT NULL default '',
  `first_name` varchar(25) binary NOT NULL default '',
  `last_name` varchar(15) binary NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `email` varchar(30) NOT NULL default '0',
  `subjects` varchar(17) NOT NULL default '',
  `class` tinyint(2) unsigned zerofill NOT NULL default '00',
  `mobile` int(10) unsigned NOT NULL default '0',
  `address` varchar(60) binary NOT NULL default 'غير معروف',
  `admin` set('0','1','2') NOT NULL default '0',
  `catch_mail` set('0','1','2','1+2') NOT NULL default '0',
  `active` set('0','1') NOT NULL default '0',
  PRIMARY KEY  (`u_id`),
  UNIQUE KEY `user_name` (`user_name`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

CREATE TABLE `message` (
  `sender_id` tinyint(2) unsigned zerofill NOT NULL default 

'00',
  `receiver_id` tinyint(2) unsigned zerofill NOT NULL default 

'00',
  `send_date` timestamp(10) NOT NULL,
  `read` set('0','1') NOT NULL default '0',
  `topic` varchar(20) NOT NULL default '',
  `the_message` varchar(255) binary NOT NULL default '',
  `imp` set('0','1','2','3') NOT NULL default '0',
  `is_junk` set('0','1') NOT NULL default '0',
  `is_trash` set('0','1') NOT NULL default '0'
) TYPE=MyISAM;

explain SELECT u.user_name, m.send_date, m.aread, m.topic, m.imp
FROM `message` m
LEFT JOIN `user` u
ON u.u_id=m.sender_id
WHERE m.receiver_id= '11'
AND m.is_junk='0'
AND m.is_trash='0'
ORDER BY m.send_date ASC