-- apps_master.upOwnerOutlet (PROCEDURE)
begin
UPDATE  m_outlet1, m_user1, m_user3
SET m_user1.UserFullName = userFullName1,
m_user3.UserGender = userGender1,
m_user1.UserPhone = userPhone1,
m_user3.UserDOB = userDOB1,
m_user1.UserEmail = userEmail1,
m_user3.UserPhoto = userPhoto1,
m_outlet1.OutletName = outletName1,
m_outlet1.OutletAddress = outletAddress1,
m_outlet1.lastUpdated = NOW(),
m_user1.lastUpdated = NOW(),
m_user3.lastUpdated = NOW(),
m_outlet1.activeYN = 'Y',
m_user1.activeYN = 'Y',
m_user3.activeYN = 'Y'
WHERE m_outlet1.OutletID = m_user1.OutletID AND
m_user1.UserID = m_user3.UserID AND
m_user1.UserID = userID1;
end