OraFAQ Forum: Reports & Discoverer » master/transaction report

Home » Developer & Programmer » Reports & Discoverer » master/transaction report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

master/transaction report [message #212682]

Sun, 07 January 2007 12:52

lune
Messages: 27
Registered: August 2006
Location: UAE

Junior Member

Hi All

I have a master /transaction report

let say for example emp table and dept table
let say there are some department that do not
have employee on it

How can I show only the department that have enployee
and remove the department without employee from the report

can anybody help me?

____
lune

Report message to a moderator

Re: master/transaction report [message #212719 is a reply to message #212682]

Sun, 07 January 2007 23:25

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If there are two tables involved, query which fetches data from them uses a join. It will, by default, omit departments that do not have employees. But if you use OUTER join, all departments will be displayed.

So, it seems that you used outer join. Have you? If so, don't use it.

Report message to a moderator