как связать две теблицы!

SELECT * FROM users,users_actions WHERE users.users_actions=users_actions.id

SELECT `famil` FROM `users`

SELECT * FROM users_actions a 
   LEFT JOIN users b 
   ON b.связующее_поле = a.id 
WHERE a.id = чему_то

--
-- Дамп данных таблицы `users`
--
[PHP]
--
-- Структура таблицы `users`
--
 
CREATE TABLE IF NOT EXISTS `users` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `famil` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `avatar` VARCHAR(255) NOT NULL,
  `login` VARCHAR(15) NOT NULL,
  `password` VARCHAR(15) NOT NULL,
  `date_reg` datetime DEFAULT NULL,
  `authoriz_last` datetime NOT NULL,
  `last_visit` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `email` VARCHAR(255) NOT NULL,
  `rights_site` VARCHAR(50) NOT NULL,
  `actions_site` VARCHAR(255) NOT NULL,
  `design` VARCHAR(55) NOT NULL,
  `status` VARCHAR(55) NOT NULL DEFAULT 'offline',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=123 ;
 
-- --------------------------------------------------------
 
--
-- Структура таблицы `users_actions`
--
 
CREATE TABLE IF NOT EXISTS `users_actions` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `soft` INT(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;[/PHP]