i have 3 tables.
leave_cri:typs of leave allowd 4 an emp
leave_eli:all typ of leaves
leave_detail:details of leave taken by an emp
i need 2 write a query 2 select data based on these 3 tables.
ie) i have 2 display these in a grid.
leave details from_leave_details ; leave typ from leave_eli oly if that typ of leave is allowd 4 that emp.
select leave_Type,emp_Leave_From,emp_Leave_To,emp_Leave_Days from leave_details inner join leave_eli on leave_details.leave_Type_Id=leave_eli.leave_Type_Id
bt i need this data to b displayed oly if the leave_Type_Id is in leave_cri.
Plz hlp me out vth the query.