Where condition failing

[imrasyed]

Hi Experts,

I have two tables.Joined them and created a third table using Resident for getting the data based on the condition of two fields coming from two  tables.

TableA:

X,Y

TableB:

X,Z

TableC:

X,Y,Z

resident TableA

where Y <=Z;

so this where condition is not working?

Where am I going wrong?

Appreciate u r help.

[imrasyed]

ok no problem Sunny.

Thanks a lot for all of this.