| |
GeekInterview.com > Interview Questions > Database > Sybase
| Print | |
Question: There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the department is assigned otherwise employee names and null value in the place department name. What is the query?
|
| July 07, 2006 00:08:50 |
#6 |
| Himu |
Testing Expert Member Since: June 2006 Total Comments: 10 |
RE: There are 2 tables, Employee and Department. There...
|
select e.empname,d.dptname from employee e,department d where e.eid=d.eid(+); |
| |
Back To Question | |
