August 30, 2007 at 12:49 pm
Hello. When I run this query I got
"The multi-part identifier gf.periodo could not be bound"
"The multi-part identifier gfdet.periodo could not be bound"
Can anyone tell me what is wrong? Thank you.
SELECTgf.periodo,
gf.folio,
gfdet.material,
pro.factor,
'CveProyecto Prorateo' = pro.proyecto,
'Nombre Proyecto Prorateo' = cproy.nombre,
'CveProyecto' = gfdet.proyecto,
'Nombre Proyecto' = catproy.nombre
FROM tblFinaDocugf
INNER JOIN tblFinaDocuLinegfdet
ON gf.folio = gfdet.folio
LEFT JOIN tblContProycatproy
ON gfdet.proyecto = catproy.proyecto
LEFT JOIN (SELECT factor = gp.factor / (SELECT sum(factor) FROM usrFinaProrGastPeri temp
WHERE temp.periodo = gf.periodo AND temp.material = gfdet.material),
gp.material,
gp.proyecto,
gp.periodo
FROM usrFinaProrGastPerigp
WHEREgp.Periodo = gf.periodo
ANDgp.material = gfdet.material)
AS pro
ON (gf.periodo = pro.periodo AND gfdet.material = pro.material)
LEFT JOIN tblContProycproy
ON pro.proyecto = cproy.proyecto
WHEREgf.periodo > '200703'
ANDgf.periodo < '200713'
AND((gf.folio LIKE 'GF%') OR (gf.folio LIKE 'GC%') OR (gf.folio LIKE 'GA%'))
ANDgf.aplicado = 1
AND(gf.poliza IS NOT NULL)
August 30, 2007 at 1:24 pm
*pro.factor isn't in the select, why do you calculate it?
*Is
'CveProyecto Prorateo' = pro.proyecto
testing if pro.proyecto is equal to the literal 'CveProyecto Prorateo'?
*
LEFT JOIN (SELECT factor = gp.factor / (SELECT sum(factor) FROM usrFinaProrGastPeri temp
WHERE temp.periodo = gf.periodo AND temp.material = gfdet.material),
gp.material,
gp.proyecto,
gp.periodo
FROM usrFinaProrGastPeri gp
WHERE gp.Periodo = gf.periodo
AND gp.material = gfdet.material)
AS pro
ON (gf.periodo = pro.periodo AND gfdet.material = pro.material)
seems to be an odd construction because there is no table that passes as "gf" in the left outerjoin construction
August 30, 2007 at 2:44 pm
I assume that gf.periodo is a datetime field, yet you are only supplying a year / month construct. Could this be a part of the issue?
Jo - gf is defined in the first from clause (about 10 lines in).
August 30, 2007 at 3:07 pm
Thank you Jo, Richard.
Jo pro.factor is in the outer select list and it is being calculated in the derived table pro.
You asked: Is 'CveProyecto Prorateo' = pro.proyecto
testing if pro.proyecto is equal to the literal 'CveProyecto Prorateo'?
Answer: No, actually this is the same as saying pro.proyecto as 'CveProyecto Prorateo'
Richard, gf.periodo is a char.
Thank you.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy