> Thanks Alan for your help. What exactly do you mean by aliasing?
>
> Mitch
>

give the fieldname in the where clause your alias as in

> > > where
> > > (
> > > (spec.pversion_id = :var_PVERSION_ID)
> > > )

if this is what you want. Is pversion_id also in the other tables?

Alan

>
> > >
> > > =====
> > > qryCurrProjSpecs:
> > >
> > > select
> > > spec.spec_id,
> > > spec.pversion_id,
> > > spec.spec_descr,
> > > spec.supplier_ref,
> > > spec.unitcost_est,
> > > spec.unitcost_act,
> > > spec.approved,
> > > spec.unitdelivcost,
> > > spec.act_leadtime,
> > > spec.est_leadtime,
> > > spec.spec_active,
> > > spectype.name_eng spectype_name,
> > > spec.specattr_fabric_id,
> > > spec.specattr_misc_id,
> > > spec.specattr_elec_id,
> > > uom.code uomcode,
> > > party.shortname supplier_shortname,
> > > spec.spectype_id
> > > from spec
> > > inner join spectype on (spec.spectype_id = spectype.spectype_id)
> > > inner join uom on (spec.uom_id = uom.uom_id)
> > > inner join party on (spec.supplier_id = party.party_id)
> > >
> > > where
> > > (
> > > (pversion_id = :var_PVERSION_ID)
> > > )
> > >