Consulta sql en vb6

Emiaj · #1 (**permalink**) 19/04/2010, 11:17

Buenos dias, soy nuevo en el foro y me gustaria que me apoyaran lo que pasa que tengo una consulta en mysql y desafortunadamente la consulta es muy larga y no cabe en una sola linea en visual basic ... y la solucion que le doy es realizar un salto de linea pero no se que instruccion lleva para que lo realize bien....

he intentado con un " guion bajo(_) al final de cada linea pero nada, auxilio.

Código:

dim  sql as string

sql = "SELECT C.id_carrera, C.nom_carrera, C.cve_oficial,D.hom_seme_1,E.muj_seme_1,F.hom_seme_2,G.muj_seme_2 ,H.hom_seme_3,I.muj_seme_3,J.hom_seme_4,K.muj_seme_4 ,L.hom_seme_5,M.muj_seme_5,N.hom_seme_6,O.muj_seme_6 ,P.hom_seme_7,Q.muj_seme_7,R.hom_seme_8,S.muj_seme_8 ,U.hom_seme_9,V.muj_seme_9,Y.hom_seme_10,Z.muj_seme_10 ,X.hom_carre_total, W.muj_carre_total FROM carrera C
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) hom_seme_1 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='H'and alumno.nc=realumno.nc and realumno.semestre = 1 and periodo='VERANO10' GROUP BY realumno.carrera
  ) D ON C.subfijo = D.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) muj_seme_1 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='M'and alumno.nc=realumno.nc and realumno.semestre = 1 and periodo='VERANO10' GROUP BY realumno.carrera
  ) E ON C.subfijo = E.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) hom_seme_2 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='H'and alumno.nc=realumno.nc and realumno.semestre = 2 and periodo='VERANO10' GROUP BY realumno.carrera
  ) F ON C.subfijo = F.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) muj_seme_2 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='M'and alumno.nc=realumno.nc and realumno.semestre = 2 and periodo='VERANO10' GROUP BY realumno.carrera
  ) G ON C.subfijo = G.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) hom_seme_3 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='H'and alumno.nc=realumno.nc and realumno.semestre = 3 and periodo='VERANO10' GROUP BY realumno.carrera
  ) H ON C.subfijo = H.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) muj_seme_3 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='M'and alumno.nc=realumno.nc and realumno.semestre = 3 and periodo='VERANO10' GROUP BY realumno.carrera
  ) I ON C.subfijo = I.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) hom_seme_4 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='H'and alumno.nc=realumno.nc and realumno.semestre = 4 and periodo='VERANO10' GROUP BY realumno.carrera
  ) J ON C.subfijo = J.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) muj_seme_4 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='M'and alumno.nc=realumno.nc and realumno.semestre = 4 and periodo='VERANO10' GROUP BY realumno.carrera
  ) K ON C.subfijo = K.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) hom_seme_5 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='H'and alumno.nc=realumno.nc and realumno.semestre = 5 and periodo='VERANO10' GROUP BY realumno.carrera
  ) L ON C.subfijo = L.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) muj_seme_5 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='M'and alumno.nc=realumno.nc and realumno.semestre = 5 and periodo='VERANO10' GROUP BY realumno.carrera
  ) M ON C.subfijo = M.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) hom_seme_6 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='H'and alumno.nc=realumno.nc and realumno.semestre = 6 and periodo='VERANO10' GROUP BY realumno.carrera
  ) N ON C.subfijo = N.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) muj_seme_6 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='M'and alumno.nc=realumno.nc and realumno.semestre = 6 and periodo='VERANO10' GROUP BY realumno.carrera
  ) O ON C.subfijo = O.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) hom_seme_7 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='H'and alumno.nc=realumno.nc and realumno.semestre = 7 and periodo='VERANO10' GROUP BY realumno.carrera
  ) P ON C.subfijo = P.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) muj_seme_7 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='M'and alumno.nc=realumno.nc and realumno.semestre = 7 and periodo='VERANO10' GROUP BY realumno.carrera
  ) Q ON C.subfijo = Q.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) hom_seme_8 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='H'and alumno.nc=realumno.nc and realumno.semestre = 8 and periodo='VERANO10' GROUP BY realumno.carrera
  ) R ON C.subfijo = R.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) muj_seme_8 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='M'and alumno.nc=realumno.nc and realumno.semestre = 8 and periodo='VERANO10' GROUP BY realumno.carrera
  ) S ON C.subfijo = S.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) hom_seme_9 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='H'and alumno.nc=realumno.nc and realumno.semestre = 9 and periodo='VERANO10' GROUP BY realumno.carrera
  ) U ON C.subfijo = U.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) muj_seme_9 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='M'and alumno.nc=realumno.nc and realumno.semestre = 9 and periodo='VERANO10' GROUP BY realumno.carrera
  ) V ON C.subfijo = V.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) hom_seme_10 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='H'and alumno.nc=realumno.nc and realumno.semestre > 9 and periodo='VERANO10' GROUP BY realumno.carrera
  ) Y ON C.subfijo = Y.carrera
LEFT JOIN
(
      SELECT realumno.carrera, count(realumno.nc) muj_seme_10 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='M'and alumno.nc=realumno.nc and realumno.semestre > 9  and periodo='VERANO10' GROUP BY realumno.carrera
  ) Z ON C.subfijo = Z.carrera
LEFT JOIN
(
      SELECT alumno.carrera, count(alumno.nc) hom_carre_total FROM carrera,alumno,realumno WHERE alumno.carrera=carrera.subfijo and alumno.sexo_per='H' and alumno.nc = realumno.nc and periodo='VERANO10' group by alumno.carrera order by realumno.semestre
  ) X ON C.subfijo = X.carrera
 LEFT JOIN
 (
      SELECT alumno.carrera, count(alumno.nc) muj_carre_total FROM carrera,alumno,realumno WHERE alumno.carrera=carrera.subfijo and alumno.sexo_per='M' and alumno.nc = realumno.nc and periodo='VERANO10' group by alumno.carrera order by realumno.semestre
 ) W ON C.subfijo = W.carrera; "

mgd · #2 (**permalink**) 19/04/2010, 12:10

Yo lo hago asi

Código MYSQL:

Ver original"SELECT C.id_carrera, C.nom_carrera, C.cve_oficial,D.hom_seme_1,E.muj_seme_1,F.hom_seme_2,G.muj_seme_2 ,H.hom_seme_3,I.muj_seme_3,J.hom_seme_4,K.muj_seme_4 ,L.hom_seme_5,M.muj_seme_5,N.hom_seme_6,O.muj_seme_6 ,P.hom_seme_7,Q.muj_seme_7,R.hom_seme_8,S.muj_seme_8 ,U.hom_seme_9,V.muj_seme_9,Y.hom_seme_10,Z.muj_seme_10 ,X.hom_carre_total, W.muj_carre_total FROM carrera C " & _
" LEFT JOIN (SELECT realumno.carrera, count(realumno.nc) hom_seme_1 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='H'and alumno.nc=realumno.nc and realumno.semestre = 1 and periodo='VERANO10' GROUP BY realumno.carrera) D ON C.subfijo = D.carrera"

Osea terminando el renglon con " & _ y empezando el siguiente solo con " y respetandos los espacion entre comillas, ampersand y guin bajo

Emiaj · #3 (**permalink**) 26/04/2010, 10:08

Cita:

Iniciado por mgd

Yo lo hago asi

Código MYSQL:

Ver original"SELECT C.id_carrera, C.nom_carrera, C.cve_oficial,D.hom_seme_1,E.muj_seme_1,F.hom_seme_2,G.muj_seme_2 ,H.hom_seme_3,I.muj_seme_3,J.hom_seme_4,K.muj_seme_4 ,L.hom_seme_5,M.muj_seme_5,N.hom_seme_6,O.muj_seme_6 ,P.hom_seme_7,Q.muj_seme_7,R.hom_seme_8,S.muj_seme_8 ,U.hom_seme_9,V.muj_seme_9,Y.hom_seme_10,Z.muj_seme_10 ,X.hom_carre_total, W.muj_carre_total FROM carrera C " & _
" LEFT JOIN (SELECT realumno.carrera, count(realumno.nc) hom_seme_1 FROM realumno,alumno WHERE alumno.carrera=realumno.carrera and alumno.sexo_per='H'and alumno.nc=realumno.nc and realumno.semestre = 1 and periodo='VERANO10' GROUP BY realumno.carrera) D ON C.subfijo = D.carrera"

Osea terminando el renglon con " & _ y empezando el siguiente solo con " y respetandos los espacion entre comillas, ampersand y guin bajo