Help required in joins

[www Developerof NET]

Hi, Here`s my problem.I have 2 tables Employee and Department as follows Employee ---------------------------------------------------------------- empid | fname | Lname | Grade | Designation | Dept_id | ---------------------------------------------------------------- Department --------------------- Dept_id |Dept_name| --------------------- I want to select empid,fname,lname,grade,designation,Dept_name I know this is very simple but i am weak in joins.Pls suggest a query such that i can select the values.

[RedhaDev]

Select empid, fname, LName, Grade, Desination, Dept_name from Employee JOIN department on Department.Dept_id = Employee.Dept_id (you cqn use LEFT JOIN to get all employees, even those have Dept_Id=null.)

Rédha.

[gauthee]

select empid,fname,lname,grade,designation,Dept_name from employee e join department d on e.dept_id=d.dept_id

Gautham

[www Developerof NET]

Thankx !!!