Searching for Mutiple Information


From value : 100000 To value : 200000

If only from value is input, information is retrieved according to this search condition. If only to value is input, information is retrieved according to this search condition. How Can I change the following SQL ?

SELECT A.EmpID
       A.EmpName
       B.DepID
       B.DepartmentName
FROM  Employee A, 
      Department B
WHERE A.EmpID = B.EmpID
     AND A.Salary BETWEEN'100000' AND '200000'

Related Posts