SELECT d.deanid,d.dean,d.artit as dname,d.entit ,d.type, d.org, dd.artit as aitem,dd.entit as eitem,dd.artxt,dd.entxt FROM deanhead d LEFT JOIN deanships dd ON d.deanid = dd.deanid WHERE d.deanid = 234 AND dd.entit = 'Acceptance'