Problemas con una consulta
Buenos dias:
tengo una tabla llamada item, en la cual se almacena un id (las iniciales de la actividad), nombre (descripcion de la actividad), y un tipo (tipo de actividad)
tengo otra tabla llamada itemusu
se utiliza para llevar el registro de la actividad de cada usuario
tiene los siguientes campos:
id (es un autoincrementable), ida (id de la actividad), idu(id del usuario), total (es el numero total de items de cada actividad)
aux (es el numero de items de cada actividad), fechar (fecha del registro)
asi por ejemplo un registro de la tabla item podria ser:
id nombre tipo
afot Analisis de fotocopias 7
y un ejemplo para itemusu seria:
id ida idu total aux fechar
01 afot 02 5 5 2010-10-10
02 afot 02 10 5 2010-10-10
EL PROBLEMA ES EL SIGUIENTE
HAY ACTIVIDADES Y ACTIVIDADES EXTRAS, TODAS ESTAN GUARDADAS EN LA TABLA ITEM.
ASI PARA OBTENER ACTIVIDADES Y ACTIVIDADES EXTRA DE CADA USUARIO, LA CONSULTA SERIA LA SIGUIENTE:
$sql3=mysql_query("select sum(ite.aux) total,it.nombre nombre from itemusu ite, item it where it.id=ite.ida and ite.idu ='$sql2[0]' and ite.fechar between '$fecha' and '$fecha2' group by it.nombre order by it.nombre desc",$link);
PERO.....COMO HARIA LA CONSULTA PARA OBTENER POR SEPARADO LAS ACTIVIDADES Y LAS ACTIVIDADES EXTRAS???
TENIENDO EN CUENTA QUE LO UNICO QUE DIFERENCIA A LAS ACTIVIDADES DE LAS ACTIVIDADES EXTRAS ES QUE LAS ACTIVIDADES EXTRAS SON DE TIPO 7, 8, 9, 10, 12 Y ESE TIPO SOLO ESTA EN LA TABLA ITEM Y NO EN LA TABLA ITEMUSU
TAMBIEN, NO SE PUEDE MODIFICAR NINGUNA DE LAS TABLAS
PERO SI SE PUEDEN CREAR
GRACIAS POR LA COLABORACION
JULIAN ROJAS
Subject
Views
Written By
Posted
54820
July 11, 2006 07:51AM
8914
July 21, 2006 09:35AM
7109
July 24, 2006 08:37AM
4203
February 25, 2010 05:22PM
6106
May 17, 2010 02:44AM
3503
August 30, 2010 08:14AM
3511
September 15, 2010 04:21PM
3885
November 09, 2010 06:58AM
6081
June 07, 2010 03:05PM
4306
August 31, 2011 05:59AM
6592
July 28, 2006 08:22AM
5775
March 15, 2008 10:59AM
5274
March 17, 2008 04:10AM
14605
April 22, 2008 01:27PM
8752
June 16, 2008 04:40PM
6635
July 28, 2006 05:43PM
7832
August 30, 2006 09:33AM
6118
July 09, 2007 10:47AM
5272
May 23, 2008 12:34AM
8836
May 17, 2008 07:03AM
6932
May 22, 2008 12:07PM
5784
July 25, 2008 12:46PM
8804
November 14, 2007 03:15AM
8813
November 14, 2007 12:26PM
6276
January 10, 2008 10:39AM
5704
March 04, 2008 11:50AM
7518
June 03, 2008 10:58AM
7181
January 17, 2009 09:27PM
5481
January 18, 2009 07:33AM
5560
January 21, 2009 07:53PM
6194
January 24, 2009 09:09PM
5267
January 22, 2009 12:12AM
5350
January 23, 2009 04:52PM
3672
March 18, 2010 07:16PM
6659
January 21, 2008 02:07PM
5800
January 21, 2008 04:04PM
9429
January 22, 2008 10:56AM
6639
January 22, 2008 02:47PM
6109
February 09, 2008 05:56AM
8068
June 13, 2011 08:59AM
7936
February 09, 2008 05:58AM
6333
February 11, 2008 05:28PM
5526
May 11, 2008 12:31PM
12117
February 12, 2008 06:04PM
7895
March 11, 2008 05:17AM
4633
April 10, 2010 06:07PM
8909
August 25, 2008 07:22PM
9208
March 23, 2008 09:27AM
5687
April 19, 2008 05:08PM
5242
May 11, 2008 12:28PM
7869
March 28, 2008 10:20AM
6846
June 05, 2008 08:21AM
5176
May 20, 2009 06:30PM
5591
April 04, 2008 08:20AM
7899
April 18, 2008 12:52PM
5124
May 20, 2009 06:27PM
5974
April 29, 2008 04:17AM
8299
May 12, 2009 02:56PM
5857
May 13, 2009 01:26AM
5743
April 30, 2008 02:21PM
5470
June 05, 2008 08:02AM
7558
May 02, 2008 01:15PM
5549
May 08, 2008 08:13PM
5485
May 05, 2008 06:25AM
5795
May 08, 2008 09:05AM
7069
May 08, 2008 03:17PM
7973
June 04, 2008 01:47PM
7030
May 19, 2008 03:50AM
5127
May 29, 2008 04:34AM
5238
May 29, 2008 05:54AM
5479
June 02, 2008 11:47AM
12079
June 04, 2008 02:01PM
5367
June 05, 2008 06:07AM
6357
June 05, 2008 07:46AM
6815
June 09, 2008 02:31AM
4925
June 09, 2008 09:53AM
5270
June 11, 2008 10:47AM
5946
June 16, 2008 06:28AM
5396
June 24, 2008 08:32PM
4432
March 26, 2009 11:07AM
4687
March 26, 2009 12:15PM
7966
September 03, 2008 04:34PM
10042
September 05, 2008 04:09AM
5604
December 14, 2008 11:49AM
7979
May 19, 2009 08:31AM
5203
May 19, 2009 08:43AM
5584
August 30, 2009 09:27PM
6087
May 26, 2009 05:30PM
4519
June 12, 2009 04:14PM
4390
July 29, 2009 08:59AM
4372
August 02, 2009 09:19PM
5111
August 02, 2009 03:18PM
4804
August 28, 2009 06:55PM
8089
August 31, 2009 03:02PM
5465
September 07, 2009 03:51AM
4019
February 24, 2010 03:37PM
5163
September 14, 2009 01:54PM
5247
September 24, 2009 09:43PM
4289
September 25, 2009 09:30AM
4644
October 07, 2009 01:51AM
6297
November 05, 2009 05:09PM
4632
November 25, 2009 06:51AM
7196
November 26, 2009 07:27AM
3715
November 26, 2009 04:13AM
4840
December 08, 2009 03:56PM
4153
December 28, 2009 10:31PM
4774
February 02, 2010 09:55AM
5194
February 11, 2010 12:06AM
11398
February 12, 2010 08:35AM
7450
February 12, 2010 09:20AM
4571
March 01, 2010 03:08PM
3860
March 03, 2010 08:23AM
5897
March 05, 2010 07:57AM
3403
March 06, 2010 04:37PM
4917
March 08, 2010 03:35PM
14078
March 29, 2010 10:12AM
4051
April 10, 2010 05:46PM
5363
April 13, 2010 03:43PM
3645
August 08, 2010 03:15PM
3457
August 08, 2010 03:54PM
2458
September 15, 2010 10:06AM
14117
September 18, 2010 10:24AM
3868
October 11, 2010 06:20PM
Problemas con una consulta
2725
October 10, 2010 10:05AM
2417
November 13, 2010 05:53AM
2741
October 18, 2010 04:05PM
2540
October 18, 2010 07:19PM
2248
October 18, 2010 07:34PM
2959
October 19, 2010 02:52PM
2920
October 25, 2010 09:30AM
2422
October 25, 2010 11:16AM
2234
January 14, 2011 05:37AM
2542
January 20, 2011 03:13PM
2621
January 23, 2011 09:41AM
3907
February 14, 2011 09:18AM
3468
January 31, 2011 04:19PM
3370
February 02, 2011 11:41AM
5193
March 03, 2011 02:57PM
2233
March 17, 2011 01:35PM
2726
July 30, 2011 10:51PM
1817
August 15, 2011 03:50PM
2872
September 20, 2011 10:54AM
1682
September 20, 2011 01:53PM
1737
October 14, 2011 08:21AM