Hi Rex.

>CREATE SQL VIEW "LV_VACCINEBRAND" ;
> AS SELECT Sbrand.*, Smanvac.imanufacturerid, Smanvac.ivaccineid, Smanufac.cname AS cmanufacturer FROM impact!smanvac INNER JOIN impact!sbrand INNER JOIN impact!smanufac ON Smanufac.iid = Smanvac.imanufacturerid ON Smanvac.iid = Sbrand.imanufacturervaccineid WHERE Sbrand.imanufacturervaccineid = ?vp_iManufacturerVaccineId

Rearrange the joins to be like this:

FROM impact!smanvac ;
INNER JOIN impact!sbrand ;
ON Smanvac.iid = Sbrand.imanufacturervaccineid ;
INNER JOIN impact!smanufac ;
ON Smanufac.iid = Smanvac.imanufacturerid ;

This works fine.

Doug