SELECT TOP 1 * FROM Community C LEFT JOIN Address A ON C.Address_ID=A.Address_ID WHERE Company_ID=272