November 07, 2003, 05:22 AM
<iamvijay>How to give where Condition
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
November 07, 2003, 01:50 PM
TewyHi 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