Tengo 3 tablas, `users`, `user_skills` y `skils` y quiero hacer un SELECT
anidado asi:
SELECT user_id FROM users WHERE firstname='Juan' AND ser_lastname='Perez'
SELECT skill_id FROM user_skill WHERE user_id=xxx
SELECT skill_name FROM skills WHERE skill_id=yyy
Se entiende ? xxx sale de la primera consulta y entra en la segunda que devuelve un skill_id=yyy que es el que necesito en la consulta final.
Necesito UNIR las tres consultas en una sola pero necesito vuestra ayuda, podra ser ?

GRACIAS!

Cita:
-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 24-04-2009 a las 14:04:50
-- Versión del servidor: 5.0.45
-- Versión de PHP: 5.2.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Base de datos: `skill_test`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `skills`
--
CREATE TABLE `skills` (
`skill_id` int(11) NOT NULL auto_increment,
`skill_name` char(100) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`skill_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;
--
-- Volcar la base de datos para la tabla `skills`
--
INSERT INTO `skills` (`skill_id`, `skill_name`) VALUES
(1, 'Excel'),
(2, 'Word'),
(3, 'PHP'),
(4, 'MySQL'),
(5, 'Delphi'),
(6, '.NET');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `users`
--
CREATE TABLE `users` (
`user_id` int(11) NOT NULL auto_increment,
`user_firstname` char(50) collate latin1_general_ci NOT NULL,
`user_lastname` char(50) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;
--
-- Volcar la base de datos para la tabla `users`
--
INSERT INTO `users` (`user_id`, `user_firstname`, `user_lastname`) VALUES
(1, 'Pedro', 'Buchon'),
(2, 'Juan', 'Perez'),
(3, 'Maria Marta', 'Gonzalez'),
(4, 'Jose', 'Acasuso');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `user_skill`
--
CREATE TABLE `user_skill` (
`user_skill_id` int(11) NOT NULL auto_increment,
`user_skill_last_modified` timestamp NULL default CURRENT_TIMESTAMP,
`user_skill_date_created` datetime default NULL,
`user_id` int(11) default NULL,
`skill_id` int(11) NOT NULL,
`skill_level` tinyint(1) default NULL,
`skill_usage` char(255) collate latin1_general_ci default NULL,
`skill_last_used` char(255) collate latin1_general_ci default NULL,
`user_skill_endorsed` tinyint(1) default NULL,
PRIMARY KEY (`user_skill_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;
--
-- Volcar la base de datos para la tabla `user_skill`
--
INSERT INTO `user_skill` (`user_skill_id`, `user_skill_last_modified`, `user_skill_date_created`, `user_id`, `skill_id`, `skill_level`, `skill_usage`, `skill_last_used`, `user_skill_endorsed`) VALUES
(1, '2009-04-24 13:43:19', NULL, 1, 3, 2, NULL, NULL, 3),
(2, '2009-04-24 13:43:19', NULL, 1, 4, 4, NULL, NULL, NULL),
(3, '2009-04-24 13:44:01', NULL, 4, 6, NULL, NULL, NULL, NULL),
(4, '2009-04-24 13:44:01', NULL, 2, 6, NULL, NULL, NULL, NULL);
-- version 2.10.3
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 24-04-2009 a las 14:04:50
-- Versión del servidor: 5.0.45
-- Versión de PHP: 5.2.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Base de datos: `skill_test`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `skills`
--
CREATE TABLE `skills` (
`skill_id` int(11) NOT NULL auto_increment,
`skill_name` char(100) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`skill_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;
--
-- Volcar la base de datos para la tabla `skills`
--
INSERT INTO `skills` (`skill_id`, `skill_name`) VALUES
(1, 'Excel'),
(2, 'Word'),
(3, 'PHP'),
(4, 'MySQL'),
(5, 'Delphi'),
(6, '.NET');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `users`
--
CREATE TABLE `users` (
`user_id` int(11) NOT NULL auto_increment,
`user_firstname` char(50) collate latin1_general_ci NOT NULL,
`user_lastname` char(50) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;
--
-- Volcar la base de datos para la tabla `users`
--
INSERT INTO `users` (`user_id`, `user_firstname`, `user_lastname`) VALUES
(1, 'Pedro', 'Buchon'),
(2, 'Juan', 'Perez'),
(3, 'Maria Marta', 'Gonzalez'),
(4, 'Jose', 'Acasuso');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `user_skill`
--
CREATE TABLE `user_skill` (
`user_skill_id` int(11) NOT NULL auto_increment,
`user_skill_last_modified` timestamp NULL default CURRENT_TIMESTAMP,
`user_skill_date_created` datetime default NULL,
`user_id` int(11) default NULL,
`skill_id` int(11) NOT NULL,
`skill_level` tinyint(1) default NULL,
`skill_usage` char(255) collate latin1_general_ci default NULL,
`skill_last_used` char(255) collate latin1_general_ci default NULL,
`user_skill_endorsed` tinyint(1) default NULL,
PRIMARY KEY (`user_skill_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;
--
-- Volcar la base de datos para la tabla `user_skill`
--
INSERT INTO `user_skill` (`user_skill_id`, `user_skill_last_modified`, `user_skill_date_created`, `user_id`, `skill_id`, `skill_level`, `skill_usage`, `skill_last_used`, `user_skill_endorsed`) VALUES
(1, '2009-04-24 13:43:19', NULL, 1, 3, 2, NULL, NULL, 3),
(2, '2009-04-24 13:43:19', NULL, 1, 4, 4, NULL, NULL, NULL),
(3, '2009-04-24 13:44:01', NULL, 4, 6, NULL, NULL, NULL, NULL),
(4, '2009-04-24 13:44:01', NULL, 2, 6, NULL, NULL, NULL, NULL);