selects

[Manoloweb]

Por cierto... si a alguien le sirve, esta es la BD que tuve que hacer para hacer las pruebas...

# MySQL-Front Dump 2.4
#
# Host: localhost Database: db
#--------------------------------------------------------
# Server version 3.23.47-nt


#
# Table structure for table 'categorias'
#

DROP TABLE IF EXISTS categorias;
CREATE TABLE `categorias` (
`IdCategoria` tinyint(3) unsigned NOT NULL auto_increment,
`Categoria` varchar(50) default NULL,
PRIMARY KEY (`IdCategoria`)
) TYPE=MyISAM;



#
# Dumping data for table 'categorias'
#
INSERT INTO categorias VALUES("1", "Herramientas");
INSERT INTO categorias VALUES("2", "Consumibles");
INSERT INTO categorias VALUES("3", "Hogar");
INSERT INTO categorias VALUES("4", "Cerraduras");


#
# Table structure for table 'subcategorias'
#

DROP TABLE IF EXISTS subcategorias;
CREATE TABLE `subcategorias` (
`IdSubCategoria` tinyint(3) unsigned NOT NULL auto_increment,
`IdCategoria` tinyint(3) unsigned default NULL,
`SubCategoria` varchar(50) default NULL,
PRIMARY KEY (`IdSubCategoria`)
) TYPE=MyISAM;



#
# Dumping data for table 'subcategorias'
#
INSERT INTO subcategorias VALUES("1", "1", "Taladros");
INSERT INTO subcategorias VALUES("2", "1", "Martillos");
INSERT INTO subcategorias VALUES("3", "1", "Sierras");
INSERT INTO subcategorias VALUES("4", "2", "Tornillos");
INSERT INTO subcategorias VALUES("5", "2", "Clavos");
INSERT INTO subcategorias VALUES("6", "2", "Alambre");
INSERT INTO subcategorias VALUES("7", "3", "Puertas");
INSERT INTO subcategorias VALUES("8", "3", "Ventanas");
INSERT INTO subcategorias VALUES("9", "3", "Pisos");
INSERT INTO subcategorias VALUES("10", "4", "Perilla");
INSERT INTO subcategorias VALUES("11", "4", "Llaves");
INSERT INTO subcategorias VALUES("12", "4", "Candados");