NVL(shopextr.extratitle, "") AS extratitle, ; NVL(shopextr.extratext, "") AS extratext;>Hello All,
>SELECT tmpShops.*, shopques.*, ; > IIF(ISNULL(shopextr.extratitle), "", shopextr.extratitle) AS extratitle, ; > IIF(ISNULL(shopextr.extratext), "", shopextr.extratext) AS extratext ; > FROM tmpShops, shopques LEFT OUTER JOIN shopextr ; > ON Shopques.shopquesid = shopextr.shopquesid ; > WHERE (shopques.shopid = tmpShops.shopid) ; > AND (shopques.shopid IN (SELECT shopid ; > FROM tmpShops)) ; > INTO CURSOR tmpExport >>