Ok, I'll try it, but the problem is that this is the code generated by VFP itself. Is this a common problem?

TIA

Rex

>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