Focal Point
How to give where Condition

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5761067331

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
Tewy
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