how to implement IF ELSE statement in my sql select

Question

kindly assist me on how to implement the code below since am getting this error

" Incorrect syntax near '{'. Incorrect syntax near the keyword 'AND'. Incorrect syntax near '}'"

      IF 
      TreatmentGroup=ALL
      {
      SELECT
      TreatmentItems.TreatmentGroup As TreatmentGroup,
      MedicalSchemeDetail.*
      FROM
      MedicalSchemeDetail JOIN TreatmentItems ON
      MedicalSchemeDetail.CompanyID = TreatmentItems.CompanyID AND 
      MedicalSchemeDetail.BranchID = TreatmentItems.BranchID AND 
      MedicalSchemeDetail.DepartmentID = TreatmentItems.DepartmentID AND
      MedicalSchemeDetail.ItemID = TreatmentItems.TreatmentID 
      WHERE
      AND MedicalSchemeDetail.CompanyID = @CompanyID 
      AND MedicalSchemeDetail.BranchID = @BranchID 
      AND MedicalSchemeDetail.DepartmentID = @DepartmentID 
      AND MedicalSchemeDetail.MedicalSchemeID = @MedicalSchemeID 
      AND IsNull(MedicalSchemeDetail.Excluded,0) = 0
      }
      ELSE
      {
      SELECT
      TreatmentItems.TreatmentGroup As TreatmentGroup,
      MedicalSchemeDetail.*
      FROM
      MedicalSchemeDetail JOIN TreatmentItems ON
      MedicalSchemeDetail.CompanyID = TreatmentItems.CompanyID AND 
      MedicalSchemeDetail.BranchID = TreatmentItems.BranchID AND 
      MedicalSchemeDetail.DepartmentID = TreatmentItems.DepartmentID AND
      MedicalSchemeDetail.ItemID = TreatmentItems.TreatmentID 
      WHERE
      TreatmentGroup=@TreatmentGroup
      AND MedicalSchemeDetail.CompanyID = @CompanyID 
      AND MedicalSchemeDetail.BranchID = @BranchID 
      AND MedicalSchemeDetail.DepartmentID = @DepartmentID 
      AND MedicalSchemeDetail.MedicalSchemeID = @MedicalSchemeID 
      AND IsNull(MedicalSchemeDetail.Excluded,0) = 0
      }

Possible duplicate of [How do write IF ELSE statement in a MySQL query](https://stackoverflow.com/questions/8763310/how-do-write-if-else-statement-in-a-mysql-query) — Feras Al Sous, Nov 07 '17 at 08:50

score 2 · Answer 1 · edited Nov 07 '17 at 08:53

2

You need to remove the AND after the first WHERE In Query

edited Nov 07 '17 at 08:53

Feras Al Sous

1,073
1
12
23

answered Nov 07 '17 at 08:49

Ko2r

1,541
1
11
24

thanks Feras, i have done that but am now getting this error.. Incorrect syntax near '{'. Incorrect syntax near '}'. Incorrect syntax near '}'. kindly just edit for me – john kc Nov 07 '17 at 09:06

how to implement IF ELSE statement in my sql select

1 Answers1