SELECT tbl_banner_selection.*,tbl_banner.promo_for FROM tbl_banner_selection LEFT OUTER JOIN tbl_banner ON tbl_banner_selection.banner_id = tbl_banner.id WHERE banner_id='9'