need help i have table in sql server with set of colunms i just want to select values between from and to columns in sql : select Q.mem_id from tb_mem_share Q,tb_member MB where MB.mem_id=Q.mem_id AND Q.share_num_from between '42368' and '42378' 

select * from tb_mem_share where share_num_from >= 42368 and share_num_from <=42378

 by giving this i can get only second record ,i need data which lies between from and to


mem_id	 share_num_from	  share_num_to	no_of_shares	share_amt	
KA003871   42360             42369          10            10000
KA000401    42370            42379          10           10000