mehulkaklotar/DailyDabba — pull request #20 by vshukla8991 (2013-11-19 12:48:27+00:00)
Title: PLease change given below procedure.

CREATE DEFINER=`root`@`localhost` PROCEDURE `getVendor`(IN `p_VendorUN` VARCHAR(50))
NO SQL
SELECT v.UserName,v.VendorName, c.CityName,c.CityID,

a.AreaID,a.AreaName, v.MobileNo, v.EmailID, v.Lane, v.OwnerName,

v.LandlineNo,v.Status, v.CustomizableFlag
FROM vendor v, city c, area a
WHERE c.CityID = a.CityID
AND a.AreaID = v.AreaID
AND v.UserName = p_VendorUN
AND v.Status = 1