DSXchange

hi

i have two tables like X and Y

tableA
sno,hiredate
1,1-1-2010
1,1-1-2010
1,4-2-2009
1,4-2-2009

tableB
sno,hiredate
1,1-1-2010
1,1-1-2010

i want to display
output like this
------------
1,4-2-2009
1,4-2-2009 ( these two records only)


Thanks&Regards
venkat

i

A join stage in your database.

When is the interview ?

Your data is not clear (wrap in Code tags), your specification less so.

Please describe in English the rule(s) for generating the expected output.