Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How to give where Condition
Go
New
Search
Notify
Tools
Reply
  
How to give where Condition
 Login/Join
 
<iamvijay>
posted
I'm new to WebFocus,

I've to display a employee record for a particular department, only if that employee record exists in the same table with a different department on a given date condition.

Thanx in advance

Vijay
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi Vijay,

Not too sure what you're trying to do. Is there only one department field or two? Are you trying to say something like

if department on 20030101 ne department on 20031001 then display the record else don't?

If you clarify your requirements I should be able to help you

Tewy
 
Posts: 123 | Location: UK | Registered: October 09, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How to give where Condition

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.