pcsoft.us.windevCopyright 2026, PC SOFT30 Mar 2015 08:20:00 Z29 Mar 2015 19:42:00 Zi am execute this sql queries in windev 17 but that is give error... SELECT QuestionMaster.QuestionMasterID AS QuestionMasterID, QuestionMaster.QM_SM_Id AS QM_SM_Id, QuestionMaster.QM_CM_ID AS QM_CM_ID, QuestionMaster.QM_DetailQuestion AS QM_DetailQuestion, QuestionMaster.QM_Name AS QM_Name, QuestionMaster.QM_AnsA AS QM_AnsA, QuestionMaster.QM_AnsB AS QM_AnsB, QuestionMaster.QM_AnsC AS QM_AnsC, QuestionMaster.QM_AnsD AS QM_AnsD, QuestionMaster.QM_CurrectAns AS QM_CurrectAns, QuestionMaster.QM_Remark AS QM_Remark, ExamSyllebs.ExamSyllebsID AS ExamSyllebsID, ExamSyllebs.ES_SM_Id AS ES_SM_Id, ExamSyllebs.ES_EM_Id AS ES_EM_Id, ExamSyllebs.ES_CM_Id AS ES_CM_Id FROM QuestionMaster LEFT OUTER JOIN ExamSyllebs ON QuestionMaster.QM_SM_Id = ExamSyllebs.ES_SM_Id WHERE ( ExamSyllebs.ES_EM_Id = {param1} AND QuestionMaster.QM_CM_ID IN (ExamSyllebs.ES_CM_Id) )30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51227-sql-queries-not-give-output/read.awpsql queries not give outputmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51227-sql-queries-not-give-output-51231/read.awp30 Mar 2015 08:20:00 Zbut sir i am use this queries (in) function AND QuestionMaster.QM_CM_ID IN (ExamSyllebs.ES_CM_Id) that is not work prop…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51227-sql-queries-not-give-output-51231/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51227-sql-queries-not-give-output-51231/read.awpsql queries not give outputRe: sql queries not give outputguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51227-sql-queries-not-give-output-51230/read.awp29 Mar 2015 20:25:00 ZHi Vijay, Why do you put a where clause if it is already included in your join selection? Use this: SELECT QuestionMaste…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51227-sql-queries-not-give-output-51230/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51227-sql-queries-not-give-output-51230/read.awpsql queries not give outputRe: sql queries not give output