Another thing I forgot to tell, both the tables are returning their records if accessed from Query Analyzer.