
If not FOUND then
Select DS-id into $DS-id from DrugShopMstr
3
AT SITE 3 where DS-city = $city;
Select mem-id into $mem-id from Order
3
AT SITE 3 where DS-id = $DS-id;
Select manu-id into $manu-id from MedicineMstr
3
AT SITE 3 where mem-id = $mem-id;
Select manu-name into $manu-name from ManufacturerMstr
3
AT SITE 3 where manu-id = $manu-id;
If not FOUND then
Select DS-id into $DS-id from DrugShopMstr
4
AT SITE 4 where DS-city = $city;
Select mem-id into $mem-id from Order
4
AT SITE 4 where DS-id = $DS-id;
Select manu-id into $manu-id from MedicineMstr
4
AT SITE 4 where mem-id = $mem-id;
Select manu-name into $manu-name from ManufacturerMstr
4
AT SITE 4 where ...