Hola, gracias por contestar. La idea es exactamente esa pero
lamentablemente me da error.
------------------------------
*De:* [email protected] [mailto:[EMAIL PROTECTED] *En nombre de *Claudia
Almeda
*Enviado el:* Lunes, 04 de Junio de 2007 11:30 a.m.
*Para:* Pablo Calafatich
*Asunto:* [dbms] Consulta
Es esto lo que queres? o yo no entendi ...
SELECT
id_club, nombre_club , ( SELECT count(id_partido)
from partidos
WHERE clubes.id_club = partidos .local
OR clubes.id_club = partidos .visitante)
as
cantidad
from
clubes
El día 4/06/07, *Pablo Calafatich* <[EMAIL PROTECTED]> escribió:
Hola a todos:
Estoy haciendo un sistema para una asociación deportiva y estoy complicado
para resolver un problema. Tengo dos tablas una de clubes y otra de
partidos. La primera tiene el codigo del club y el nombre (esta
simplificada
para hacerlo mas facil). La segunda tiene los partidos jugados de todas
las
divisiones, de todas las fechas de todas las zonas de todos los sexos. Los
partidos es un INNER JOIN entre las dos tablas con los campos local y
visitante que contienen los id_club de la otra tabla, por este lado todo
bien.
El problema esta en la tabla de posiciones que quiero crear. La idea es
combinar las dos tablas para hacer la tabla de posiciones en una sola
consulta sql. Estoy tratando de hacerlo con subquerys pero me da continuos
errores
Aca paso el SQL de las tablas:
DROP TABLE IF EXISTS `clubes`;
CREATE TABLE `clubes` (
`id_club` tinyint(4) NOT NULL auto_increment,
`nombre_club` char(30) collate latin1_spanish_ci NOT NULL,
PRIMARY KEY (`id_club`)
)
INSERT INTO `clubes` VALUES (1, 'Club01');
INSERT INTO `clubes` VALUES (2, ' Club02');
INSERT INTO `clubes` VALUES (3, ' Club03');
INSERT INTO `clubes` VALUES (4, ' Club04');
INSERT INTO `clubes` VALUES (5, ' Club05');
INSERT INTO `clubes` VALUES (6, ' Club06');
INSERT INTO `clubes` VALUES (7, ' Club07');
INSERT INTO `clubes` VALUES (8, ' Club08');
INSERT INTO `clubes` VALUES (9, ' Club09');
INSERT INTO `clubes` VALUES (10, ' Club10');
INSERT INTO `clubes` VALUES (11, ' Club11');
INSERT INTO `clubes` VALUES (12, ' Club12');
INSERT INTO `clubes` VALUES (13, ' Club13');
INSERT INTO `clubes` VALUES (14, ' Club14');
INSERT INTO `clubes` VALUES (15, ' Club15');
--
-- Estructura de tabla para la tabla `partidos`
--
DROP TABLE IF EXISTS `partidos`;
CREATE TABLE `partidos` (
`id_partido` smallint(5) unsigned NOT NULL auto_increment,
`id_torneo` tinyint(2) unsigned NOT NULL,
`id_zona` tinyint(2) unsigned NOT NULL,
`id_sexo` tinyint(2) unsigned NOT NULL,
`id_categoria` tinyint(2) unsigned NOT NULL,
`fecha` varchar(10) collate latin1_spanish_ci NOT NULL,
`hora` time default NULL,
`jornada` tinyint(2) unsigned NOT NULL,
`local` tinyint(2) unsigned NOT NULL,
`goleslocal` smallint(2) unsigned default NULL,
`golesvisitante` smallint(2) unsigned default NULL,
`visitante` tinyint(2) unsigned NOT NULL,
`ganadorlocal` smallint(1) unsigned default NULL,
`perdedorlocal` smallint(1) unsigned default NULL,
`ganadorvisitante` smallint(1) unsigned default NULL,
`perdedorvisitante` smallint(1) unsigned default NULL,
`estado` tinyint(2) default NULL,
PRIMARY KEY (`id_partido`)
)
--
-- Volcar la base de datos para la tabla `partidos`
--
INSERT INTO `partidos` VALUES (1, 1, 1, 1, 1, '17/03/2007', '00:00:00', 1,
13, 2, 0, 1, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (2, 1, 1, 1, 2, '17/03/2007', '00:00:00', 1,
13, 1, 0, 1, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (3, 1, 1, 1, 5, '17/03/2007', '00:00:00', 1,
13, 0, 1, 1, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (4, 1, 1, 1, 6, '17/03/2007', '00:00:00', 1,
13, 0, 3, 1, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (5, 1, 1, 1, 1, '17/03/2007', '00:00:00', 1,
2, 2, 0, 14, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (6, 1, 1, 1, 2, '17/03/2007', '00:00:00', 1,
2, 0, 2, 14, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (7, 1, 1, 1, 5, '17/03/2007', '00:00:00', 1,
2, 1, 1, 14, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (8, 1, 1, 1, 6, '17/03/2007', '00:00:00', 1,
2, 0, 0, 14, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (9, 1, 1, 1, 1, '17/03/2007', '00:00:00', 1,
3, 0, 1, 11, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (10, 1, 1, 1, 2, '17/03/2007', '00:00:00',
1,
3, 3, 0, 11, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (11, 1, 1, 1, 5, '17/03/2007', '00:00:00',
1,
3, 2, 1, 11, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (12, 1, 1, 1, 6, '17/03/2007', '00:00:00',
1,
3, 1, 0, 11, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (13, 1, 2, 1, 1, '17/03/2007', '00:00:00',
1,
12, 1, 1, 4, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (14, 1, 2, 1, 2, '17/03/2007', '00:00:00',
1,
12, 1, 1, 4, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (15, 1, 2, 1, 5, '17/03/2007', '00:00:00',
1,
12, 0, 1, 4, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (16, 1, 2, 1, 6, '17/03/2007', '00:00:00',
1,
12, 0, 1, 4, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (17, 1, 2, 1, 1, '17/03/2007', '00:00:00',
1,
5, 0, 4, 15, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (18, 1, 2, 1, 2, '17/03/2007', '00:00:00',
1,
5, 0, 7, 15, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (19, 1, 2, 1, 5, '17/03/2007', '00:00:00',
1,
5, 0, 6, 15, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (20, 1, 2, 1, 6, '17/03/2007', '00:00:00',
1,
5, 0, 12, 15, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (21, 1, 2, 1, 1, '17/03/2007', '00:00:00',
1,
7, 0, 7, 6, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (22, 1, 2, 1, 2, '17/03/2007', '00:00:00',
1,
7, 0, 3, 6, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (23, 1, 2, 1, 5, '17/03/2007', '00:00:00',
1,
7, 1, 0, 6, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (24, 1, 2, 1, 6, '17/03/2007', '00:00:00',
1,
7, 3, 1, 6, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (25, 1, 1, 1, 1, '24/03/2007', '00:00:00',
2,
14, 0, 2, 13, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (26, 1, 1, 1, 2, '24/03/2007', '00:00:00',
2,
14, 1, 0, 13, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (27, 1, 1, 1, 5, '24/03/2007', '00:00:00',
2,
14, 0, 0, 13, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (28, 1, 1, 1, 6, '24/03/2007', '00:00:00',
2,
14, 1, 0, 13, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (29, 1, 1, 1, 1, '24/03/2007', '00:00:00',
2,
2, 1, 2, 11, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (30, 1, 1, 1, 2, '24/03/2007', '00:00:00',
2,
2, 2, 0, 11, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (31, 1, 1, 1, 5, '24/03/2007', '00:00:00',
2,
2, 0, 2, 11, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (32, 1, 1, 1, 6, '24/03/2007', '00:00:00',
2,
2, 1, 0, 11, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (33, 1, 1, 1, 1, '24/03/2007', '00:00:00',
2,
3, 3, 0, 1, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (34, 1, 1, 1, 2, '24/03/2007', '00:00:00',
2,
3, 1, 1, 1, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (35, 1, 1, 1, 5, '24/03/2007', '00:00:00',
2,
3, 1, 0, 1, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (36, 1, 1, 1, 6, '24/03/2007', '00:00:00',
2,
3, 2, 0, 1, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (37, 1, 2, 1, 1, '24/03/2007', '00:00:00',
2,
15, 4, 0, 12, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (38, 1, 2, 1, 2, '24/03/2007', '00:00:00',
2,
15, 1, 0, 12, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (39, 1, 2, 1, 5, '24/03/2007', '00:00:00',
2,
15, 3, 0, 12, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (40, 1, 2, 1, 6, '24/03/2007', '00:00:00',
2,
15, 1, 1, 12, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (41, 1, 2, 1, 1, '24/03/2007', '00:00:00',
2,
5, 5, 0, 7, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (42, 1, 2, 1, 2, '24/03/2007', '00:00:00',
2,
5, 0, 1, 7, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (43, 1, 2, 1, 5, '24/03/2007', '00:00:00',
2,
5, 0, 0, 7, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (44, 1, 2, 1, 6, '24/03/2007', '00:00:00',
2,
5, 0, 2, 7, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (45, 1, 2, 1, 1, '24/03/2007', '00:00:00',
2,
6, 1, 2, 4, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (46, 1, 2, 1, 2, '24/03/2007', '00:00:00',
2,
6, 1, 0, 4, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (47, 1, 2, 1, 5, '24/03/2007', '00:00:00',
2,
6, 1, 1, 4, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (48, 1, 2, 1, 6, '24/03/2007', '00:00:00',
2,
6, 0, 5, 4, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (49, 1, 1, 1, 1, '31/03/2007', '00:00:00',
3,
11, 0, 0, 14, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (50, 1, 1, 1, 2, '31/03/2007', '00:00:00',
3,
11, 0, 1, 14, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (51, 1, 1, 1, 5, '31/03/2007', '00:00:00',
3,
11, 5, 0, 14, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (52, 1, 1, 1, 6, '31/03/2007', '00:00:00',
3,
11, 1, 0, 14, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (53, 1, 1, 1, 1, '31/03/2007', '00:00:00',
3,
3, 1, 1, 13, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (54, 1, 1, 1, 2, '31/03/2007', '00:00:00',
3,
3, 0, 0, 13, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (55, 1, 1, 1, 5, '31/03/2007', '00:00:00',
3,
3, 1, 1, 13, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (56, 1, 1, 1, 6, '31/03/2007', '00:00:00',
3,
3, 4, 0, 13, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (57, 1, 1, 1, 1, '31/03/2007', '00:00:00',
3,
1, 0, 0, 2, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (58, 1, 1, 1, 2, '31/03/2007', '00:00:00',
3,
1, 0, 0, 2, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (59, 1, 1, 1, 5, '31/03/2007', '00:00:00',
3,
1, 0, 1, 2, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (60, 1, 1, 1, 6, '31/03/2007', '00:00:00',
3,
1, 2, 1, 2, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (61, 1, 2, 1, 1, '31/03/2007', '00:00:00',
3,
7, 0, 9, 15, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (62, 1, 2, 1, 2, '31/03/2007', '00:00:00',
3,
7, 0, 2, 15, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (63, 1, 2, 1, 5, '31/03/2007', '00:00:00',
3,
7, 0, 6, 15, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (64, 1, 2, 1, 6, '31/03/2007', '00:00:00',
3,
7, 2, 1, 15, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (65, 1, 2, 1, 1, '31/03/2007', '00:00:00',
3,
6, 0, 0, 12, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (66, 1, 2, 1, 2, '31/03/2007', '00:00:00',
3,
6, 0, 0, 12, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (67, 1, 2, 1, 5, '31/03/2007', '00:00:00',
3,
6, 0, 0, 12, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (68, 1, 2, 1, 6, '31/03/2007', '00:00:00',
3,
6, 0, 0, 12, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (69, 1, 2, 1, 1, '31/03/2007', '00:00:00',
3,
12, 0, 0, 5, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (70, 1, 2, 1, 2, '31/03/2007', '00:00:00',
3,
12, 3, 0, 5, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (71, 1, 2, 1, 5, '31/03/2007', '00:00:00',
3,
12, 3, 0, 5, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (72, 1, 2, 1, 6, '31/03/2007', '00:00:00',
3,
12, 11, 0, 5, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (73, 1, 1, 1, 1, '21/04/2007', '00:00:00',
4,
14, 1, 3, 3, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (74, 1, 1, 1, 2, '21/04/2007', '00:00:00',
4,
14, 0, 0, 3, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (75, 1, 1, 1, 5, '21/04/2007', '00:00:00',
4,
14, 0, 0, 3, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (76, 1, 1, 1, 6, '21/04/2007', '00:00:00',
4,
14, 1, 6, 3, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (77, 1, 1, 1, 1, '21/04/2007', '00:00:00',
4,
1, 1, 0, 11, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (78, 1, 1, 1, 2, '21/04/2007', '00:00:00',
4,
1, 1, 0, 11, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (79, 1, 1, 1, 5, '21/04/2007', '00:00:00',
4,
1, 1, 0, 11, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (80, 1, 1, 1, 6, '21/04/2007', '00:00:00',
4,
1, 0, 1, 11, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (81, 1, 1, 1, 1, '21/04/2007', '00:00:00',
4,
13, 2, 2, 2, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (82, 1, 1, 1, 2, '21/04/2007', '00:00:00',
4,
13, 1, 0, 2, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (83, 1, 1, 1, 5, '21/04/2007', '00:00:00',
4,
13, 1, 3, 2, 0, 1, 1, 0, 3);
INSERT INTO `partidos` VALUES (84, 1, 1, 1, 6, '21/04/2007', '00:00:00',
4,
13, 1, 0, 2, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (85, 1, 2, 1, 1, '21/04/2007', '00:00:00',
4,
15, 0, 0, 6, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (86, 1, 2, 1, 2, '21/04/2007', '00:00:00',
4,
15, 0, 0, 6, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (87, 1, 2, 1, 5, '21/04/2007', '00:00:00',
4,
15, 0, 0, 6, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (88, 1, 2, 1, 6, '21/04/2007', '00:00:00',
4,
15, 0, 0, 6, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (89, 1, 2, 1, 1, '21/04/2007', '00:00:00',
4,
4, 5, 0, 7, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (90, 1, 2, 1, 2, '21/04/2007', '00:00:00',
4,
4, 1, 0, 7, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (91, 1, 2, 1, 5, '21/04/2007', '00:00:00',
4,
4, 1, 1, 7, 0, 0, 1, 1, 3);
INSERT INTO `partidos` VALUES (92, 1, 2, 1, 6, '21/04/2007', '00:00:00',
4,
4, 2, 0, 7, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (93, 1, 2, 1, 6, '22/04/2007', '00:00:00',
4,
12, 3, 0, 5, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (94, 1, 2, 1, 6, '23/04/2007', '00:00:00',
4,
12, 8, 1, 5, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (95, 1, 2, 1, 6, '24/04/2007', '00:00:00',
4,
12, 1, 0, 5, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (96, 1, 2, 1, 6, '25/04/2007', '00:00:00',
4,
12, 8, 0, 5, 1, 0, 0, 1, 3);
INSERT INTO `partidos` VALUES (97, 1, 1, 1, 1, '28/04/2007', '00:00:00',
5,
14, 0, 0, 1, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (98, 1, 1, 1, 2, '28/04/2007', '00:00:00',
5,
14, 0, 0, 1, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (99, 1, 1, 1, 5, '28/04/2007', '00:00:00',
5,
14, 0, 0, 1, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (100, 1, 1, 1, 6, '28/04/2007', '00:00:00',
5,
14, 0, 0, 1, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (101, 1, 1, 1, 1, '28/04/2007', '00:00:00',
5,
2, 0, 0, 3, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (102, 1, 1, 1, 2, '28/04/2007', '00:00:00',
5,
2, 0, 0, 3, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (103, 1, 1, 1, 5, '28/04/2007', '00:00:00',
5,
2, 0, 0, 3, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (104, 1, 1, 1, 6, '28/04/2007', '00:00:00',
5,
2, 0, 0, 3, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (105, 1, 1, 1, 1, '28/04/2007', '00:00:00',
5,
13, 0, 0, 11, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (106, 1, 1, 1, 2, '28/04/2007', '00:00:00',
5,
13, 0, 0, 11, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (107, 1, 1, 1, 5, '28/04/2007', '00:00:00',
5,
13, 0, 0, 11, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (108, 1, 1, 1, 6, '28/04/2007', '00:00:00',
5,
13, 0, 0, 11, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (109, 1, 2, 1, 1, '28/04/2007', '00:00:00',
5,
15, 0, 0, 4, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (110, 1, 2, 1, 2, '28/04/2007', '00:00:00',
5,
15, 0, 0, 4, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (111, 1, 2, 1, 5, '28/04/2007', '00:00:00',
5,
15, 0, 0, 4, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (112, 1, 2, 1, 6, '28/04/2007', '00:00:00',
5,
15, 0, 0, 4, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (113, 1, 2, 1, 1, '28/04/2007', '00:00:00',
5,
5, 0, 0, 6, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (114, 1, 2, 1, 2, '28/04/2007', '00:00:00',
5,
5, 0, 0, 6, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (115, 1, 2, 1, 5, '28/04/2007', '00:00:00',
5,
5, 0, 0, 6, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (116, 1, 2, 1, 6, '28/04/2007', '00:00:00',
5,
5, 0, 0, 6, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (117, 1, 2, 1, 1, '28/04/2007', '00:00:00',
5,
12, 0, 0, 7, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (118, 1, 2, 1, 2, '28/04/2007', '00:00:00',
5,
12, 0, 0, 7, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (119, 1, 2, 1, 5, '28/04/2007', '00:00:00',
5,
12, 0, 0, 7, 0, 0, 0, 0, 1);
INSERT INTO `partidos` VALUES (120, 1, 2, 1, 6, '28/04/2007', '00:00:00',
5,
12, 0, 0, 7, 0, 0, 0, 0, 1);
La idea era hacer algo como:
SELECT id_club, nombre_club from clubes (SELECT count(id_partido) from
partidos WHERE clubes.id_club = partidos.local OR clubes.id_club =
partidos.visitante)
para contar los partidos jugados por cada equipo y luego agregar mas
subqueries para contar partidos ganados, empatados y perdidos, goles a
favor
en contra y puntos de cada equipo. Pero no lo pude lograr. Ya en esto solo
me da error, probe de diferentes formas todo el fin de semana y no le
encuentro la vuelta, asi que estoy pensando en ir calculando todos los
SELECT en forma individual, cargarlos en una matriz y luego ordenar la
matriz por la columna de los puntos, pero se que no es la mejor manera, en
todos lados encuentro que siempre es preferible obtener este tipo de
resultados por una consulta (query). Alguno tiene idea si es posible
resolver esta cuestion con una consulta?????
--
Atte Almeda Claudia
