using or operator

and operator displays record when all conditions are true.

And operator use like as

select * from employee

where lastname='samejo' and firstname='shahzad'

more detail visit following