mysql - Query is not joining correctly, how do I fix it? -


i have large query structured this:

there bunch of tables main table lt_chc_tours_rsv_cs has t_dt column.

there ltr_chc_tours_rsv_price has season value.

there tr_season has season value of own (corresponding ltr_chc_tours_rsv_price) has start_dt , end_dt fields

what want in query join has p.season field has correspond a.t_dt date falls in between tr_season start_dt , end_dt , don't know how this.

i'm not sure if i'm explaining correctly.

tables

tr_season

season desc    start_dt   end_dt 1     s1      1/1/2013   12/31/2013 2     s2      1/1/2014   12/31/2014 3     s3      1/1/2015   12/31/2015

ltr_chc_tours_rsv_price

season  price1   price2   price3 1        4         5        7 1        2         6        8      1        7         5        9

lt_chc_tours_rsv_cs

t_dt      count 2/5/2013    6 2/7/2014    2 8/2/2015    3

season's matched , counts multiplied pricing.

my query (unfinished)

select * -- bunch of stuff  lt_chc_tours_rsv_cs left outer join lv_customer_info1 b         on a.grp_attending = b.customer_no left outer join lv_chc_order_detail_info o  on a.order_no = o.order_no  left outer join ltr_chc_tours_rsv_price p   on /*this i'm stuck*/

what this?

select * -- bunch of stuff  lt_chc_tours_rsv_cs left outer join lv_customer_info1 b         on a.grp_attending = b.customer_no left outer join lv_chc_order_detail_info o  on a.order_no = o.order_no  join tr_season s     on a.t_dt between s.start_dt , s.end_dt join ltr_chc_tours_rsv_price p   on s.id = p.season

this way can @ t_dt field , should between start_dt , end_dt , use id in field join.


-

Popular posts from this blog

debugging - Reference - What does this error mean in PHP? -

what this? this number of answers warnings, errors , notices might encounter while programming php , have no clue how fix. community wiki, invited participate in adding , maintaining list. why this? questions "headers sent" or "calling member of non-object" pop on stack overflow. root cause of questions same. answers questions typically repeat them , show op line change in his/her particular case. these answers not add value site because apply op's particular code. other users having same error can not read solution out of because localized. sad, because once understood root cause, fixing error trivial. hence, list tries explain solution in general way apply. what should here? if question has been marked duplicate of this, please find error message below , apply fix code. answers contain further links investigate in case shouldn't clear general answer alone. if want contribute, please add "favorite" error message, warning or notic...
Read more

c++ - Why doesn't unordered_set provide an array access operator -

i'm curious why stl container unordered_set , has constant time complexity random access on average, not provide method accessing elements distance first element in container. example: t& unordered_set::operator[](size_t index) { return *(begin() + index); } accessing element "by distance" implies there meaningful way measure distance. trouble std::unordered_set is is, well, unordered . hence, there no meaningful way of explaining "some distance beginning" in non-arbitrary way. if want access distance, copy data vector: std::vector tmp(unordered.begin(), unordered.end());
Read more