how to join two conditions in one query

Hope you want to do this

select name,code from emp where curr_date=getdate() and sign='ABAN'

u should learn to solve these simple things , let it be. refer the following that might help you
http://www.databasedev.co.uk/sql-multiple-conditions.html[^]

If you want to search data for current date I take that you're not interested on the time portion. If the field in the database contains time you could use something like:

select  ...
from yourtable
where convert(date, curr_date) = convert(date, getdate())
and sign = 'ABAN'

I question does not provide fields name for your table still you can try the following concept :

Select [your desired fields separated by comma ] from emp Where (CONVERT(DATETIME,curr_date,103)=CONVERT(DATETIME,GETDATE(),103))and (sig='ABAN')