|
| sql queries not give output |
| Iniciado por guest, 29,mar. 2015 19:42 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 29,marzo 2015 - 19:42 |
i 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)
) |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,marzo 2015 - 20:25 |
Hi Vijay,
Why do you put a where clause if it is already included in your join selection?
Use this:
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}
Cheers,
Peter H. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,marzo 2015 - 08:20 |
but sir
i am use this queries (in) function
AND QuestionMaster.QM_CM_ID IN (ExamSyllebs.ES_CM_Id)
that is not work proper |
| |
| |
| | | |
|
| | | | |
| | |
|