SP: g4e_Photo_byPromoter Table 'c3ticket.PromoterPhoto' doesn't exist SELECT * FROM PromoterPhoto WHERE activeInd = 'Y' AND promoterId = '292' ORDER BY position