>h1 = 4 >TEXT TO csql NOSHOW PRETEXT 7 >SELECT inv.inp_Vendor, > inv.inp_Long_Item_Name, > inv.inp_Long_Item_Number, > prc.own_Owner_Code, > prc.inp_Short_Item_Number, > prc.prl_Price_List_Code, > prc.pri_term, > prc.pri_Current_Price, > itm.vit_Sku, > brk.vpb_Vendor_Unit_Price, > ity.ity_Inventory_Type_Name > FROM dbo.tblInventoryPrice prc > JOIN dbo.tblInventoryPrimary inv > ON prc.inp_Short_Item_Number = inv.inp_Short_Item_Number > JOIN dbo.tblVendorItem itm > ON inv.inp_Short_Item_Number + inv.inp_Vendor = itm.inp_Short_Item_Number + itm.ven_Vendor_Name > JOIN dbo.tblVendorItemPriceBreak brk > ON itm.vit_Sku + itm.ven_Vendor_Name = brk.vit_Sku + brk.ven_Vendor_Name > JOIN dbo.tblInventoryType ity > ON inv.ity_Inventory_Type_Code = ity.ity_Inventory_Type_Code > WHERE inv.inp_vendor = 'GAMINC' >ENDTEXT >?SQLEXEC(h1,csql,'results') >>Can anyone suggest where I should start looking to resolve this?