SELECT
 A.bno as bno,
 C.shortName as severityString,
 D.shortName as resolutionString,
 A.status as status,
 A.issuer as issuer,
 A.auther as auther,
 A.analyst as analyst,
 A.updater as updater,
 A.comfirmer as comfirmer,
 A.title as title,
 B.shortName as functionString,
 A.statusWhitebord as statusWhitebord,
 A.issuDate as issuDate,
 A.bugUpdateDate as bugUpdateDate,
 A.comfirmDate as comfirmDate
 FROM bug AS A
 LEFT JOIN functionName AS B ON A.functionName = B.code 
 LEFT JOIN severity AS C ON A.severity = C.code 
 LEFT JOIN resolution AS D ON A.resolution = D.code 
 where bno = 1 or bno = 2 or bno = 3
 GROUP BY A.bno 
 ORDER BY A.bno
