showing the output using sql server

  select f.bfid,f.bthid,b.class,b.bthno from bthfac f,batch b where month(b.examdate)= 9
    and year(b.examdate)= 2011 and b.bthid = f.bthid and f.facid = '4,6,9';


  when i execute the above query output as follows;


  bfid  bfid    Class     Bthno
  18    18    AFF       BAFFTEST

select r.rate,f.bfid,f.bthid,b.class,b.bthno from bthfac f,batch b,facfeedback r where month(b.examdate)= 9
    and year(b.examdate)= 2011 and b.bthid = f.bthid  and r.bfid = f.bfid and f.facid = '4,6,9';

Rgds,
Rao