You have an error in your SQL syntax near 'where a.ctsp_xcode = b.xcode and a.ctsp_lcode = b.mcode and a.ctsp_mcode = b.sco' at line 1쿼리내용 - 메인 제품 추출
쿼리 - select a.ctsp_xcode,a.ctsp_lcode,a.ctsp_scode,a.ctsp_output_chk,b.* from visslo_com_eng_category_super_manger a inner join visslo_com_eng_good_super_manager b where a.ctsp_xcode = b.xcode and a.ctsp_lcode = b.mcode and a.ctsp_mcode = b.scode and a.ctsp_output_chk = '1' and b.check_output = 'yes' and b.main_check_output ='yes' order by b.rank desc,b.idx desc
쿼리 - select a.ctsp_xcode,a.ctsp_lcode,a.ctsp_scode,a.ctsp_output_chk,b.* from visslo_com_eng_category_super_manger a inner join visslo_com_eng_good_super_manager b where a.ctsp_xcode = b.xcode and a.ctsp_lcode = b.mcode and a.ctsp_mcode = b.scode and a.ctsp_output_chk = '1' and b.check_output = 'yes' and b.main_check_output ='yes' order by b.rank desc,b.idx desc