hi
i want to know how to fetch data by giving more than two condition...please tell me wat should i use

eg

i have a query
SELECT * from post_resume WHERE ind_type='IT'and career='Engineering'...

thanks......

thanks it is working.........

i have a form where the candidate id,from-date and to-date will be given by the user..based on tat i want to exact data from the table

SELECT * from attend where...

Subquery returns more than 1 row

i have three table

1st viewleave
2nd applyleave
3rd personal

based on the leaveid in viewleavetable i wnt to fetch the spid in the second table,based on the spid i want to select spid email...