Doug,

All are tables. The message I normally get the first time is that it can't find iManufacturerId.

Strange!

Thanks

Rex
>>CREATE SQL VIEW "LV_VACCINEBRAND" ;
>>AS ;
>> SELECT ;
>> Imc_bran.iid, ;
>> Imc_bran.imanufacturervaccineid, ;
>> Imc_bran.cname, ;
>> Imc_bran.dAvailable, ;
>> Imc_bran.iminage, ;
>> Imc_bran.imaxage, ;
>> Imc_bran.imaxdose, ;
>> Imc_bran.imindose, ;
>> Imc_mava.imanufacturerid, ;
>> Imc_mava.ivaccineid, ;
>> Imc_manu.cname AS cmanufacturername ;
>> FROM ;
>> impact!imc_mava ;
>> INNER JOIN impact!imc_bran ;
>> INNER JOIN impact!imc_manu ;
>> ON Imc_manu.iid = Imc_mava.imanufacturerid ;
>> ON Imc_mava.iid = Imc_bran.imanufacturervaccineid ;
>> WHERE ;
>> Imc_Bran.iManufacturerVaccineid = ?vp_iManufacturerVaccineId
>
>Are these all tables or are any of them a view? Basing views on views can be a little tricky sometimes. If not, then I can't see a reason why you get this error.
>
>Doug