SELECT F.*, FD.Description FROM Firm F LEFT JOIN FirmDescription FD ON F.FirmId=FD.FirmId WHERE F.FirmId =