Q&A for professional and enthusiast programmers
SELECT PendingFlags.*, CloseReasonTypes.* FROM PendingFlags INNER JOIN CloseReasonTypes ON CloseReasonTypeId=CloseReasonTypes.Id WHERE FlagTypeId=14