Member Avatar for ssreevidya.m

Hai ,
I have 2 tables

1. Transport_Details having columns
user_id
FareStageId
StartDate
EndDate


and
2. Route_Fee having columns
FareStageId
monthId
fees

I need to get a monthwise list by passing monthid.
But my problem is that , if start date and enddate of a user are 02-08-2011 and
20-02-2012 and I need to get the list of 4th month , this user also listed.

Query I used is:

select Transport_Details.User_Id, Route_Fee.Fee, from Transport_Details  join  Route_Fee 
on Transport_Details.Bus_Route_Fare_Stage_Id=Route_Fee.Bus_Route_Fare_Stage_Id where Route_Fee.Month=4

Can i get the list of those users , the monthid between startdate and enddate.

Thanks in advance.

  • 2 Contributors
  • 1 Reply
  • 120 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by urtrivedi
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.