Hello! This may be a silly question, but just in case I ask it anyway...

Is there any problem in doing something like this?

select
d.descripcion,
d.cantidad,
p.id as id_plan_ctas,
p.descripcion as desc_plan_ctas

from fac_ven_detalle d
left join cont_plan p on ((d.plan_ctas = p.codigo) and
(p.id_cont_periodo = :id_periodo))

where
(f.fecha between :desde and :hasta)


I mean, I'm using the ":id_periodo" param inside the join part of the
query. Of course, it works ok, but I just wander if this is the best way
to do it... or should I move it to the "where" part, like this?

select
d.descripcion,
d.cantidad,
p.id as id_plan_ctas,
p.descripcion as desc_plan_ctas

from fac_ven_detalle d
left join cont_plan p on (d.plan_ctas = p.codigo)

where
(f.fecha between :desde and :hasta)
and
(p.id_cont_periodo = :id_periodo)

thanks!!!!!!

-s


[Non-text portions of this message have been removed]