Trying to find Mutiple Info
From worth : 100000 To worth : 200000
If solely from worth is enter, data is retrieved in accordance with this search situation. If solely to worth is enter, data is retrieved in accordance with this search situation. How Can I modify the next SQL ?
SELECT A.EmpID
A.EmpName
B.DepID
B.DepartmentName
FROM Worker A,
Division B
WHERE A.EmpID = B.EmpID
AND A.Wage BETWEEN'100000' AND '200000'