ok let's back up and start

A

Alejandra Parra

I have 3 tables:

Tbl_alumnos :

str_cvealumno Str_nombre str_numerolista
----------------------------------------------------------
CODE1 NAME 1
CODE2 NAME 2
CODE3 NAME 3
.....

Tbl_DatosCaptura:

str_cvedato str_descripcion
---------------------------------------
DATA1 DESCRIPTION
DATA2 DESCRIPTION
DATA3 DESCRIPTION
....

Tbl_calificaciones:

str_cvealumno str_cvedato str_cvevalor
---------------------------------------------------
CODE1 DATA1 10
CODE1 DATA2 9
CODE2 DATA1 9.5
......

Tbl_alumnos and Tbl_DatosCaptura will always have data in them.
Tbl_Calificaciones won't

I want to get this

STR_NUMEROLISTA |STR_NOMBRE | DATA1 | DATA2 | DATA3 ------>
ALL DESCRIPTIONS IN TBL_DATOS CAPTURA
----------------------------------------------------------------------------
---------
1 | NAME | 10
| 9 |
2 | NAME | 9.5
| |
3 | NAME |
| |

|
\____________________/
|
|
|
STR_VALOR IN
V
MATCHING STR_CVEALUMNO - STR_CVEDATO
ALL STR_NUMEROLISTA IN
TBL_CALIFICACIONES
AND STR_NOMBRE IN
TBL_ALUMNOS
 
Top