SQL Server Transact Basic to Expert - Select Query using combined search

This blog shows on how to do a combined search of a table using the where clause

Syntax:
SELECT Column_list
FROM table
Where Column1="" and Column2=""

Example:
Select empname
from emptable
where empid = '10' and empsal = "1500"