how get output selected records

harikumar · Post by **harikumar** » Thu May 20, 2010 6:23 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu May 20, 2010 7:26 am

A join stage in your database.

When is the interview ?

ray.wurlod · Post by **ray.wurlod** » Thu May 20, 2010 7:37 am

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.