SQL问题,请帮忙
SELECT HG1,HG2,HG3,HG4,HG5,HG7,HG8,HG9,HG11,HG12,HG13,HG14,HG15,HG16,H,
JG1,JG2,JG3,JG4,JG5,JG7,JG8,JG9,JG10,JG11,JG12,JG13,JG14,JG15,E FROM MF_BFCA WHERE BFA_NO = 'BFD6C06003'
HG字段的的值一共只有二个,'合格','不合格' 请问我如何在这么多HG中判断出'不合格'的值,然后把它相对应的JG里面的值,AS到另外的字段中去呢?