I've been tasked with finding the subscription package types for each person in a list within a given period of time. Despite working with Tessitura for that last two years, I have yet to master the Gordian knot of table connections that make up a given customer's subscription history. Would one of you Tessitura veterans be willing to give me hand in laying out the path from T_LIST_CONTENTS.customer_no to TR_PKG_TYPE.description (in terms of what tables are necessary to construct this ridiculous request)?
I'm sure there's some all-powerful document that explains exactly how to do this in our documentation directory on the server, but I'm not very good at making use of that resource, I admit. Thank you in advance, as always, Tessiturians.
MEAGER TRIVIA OFFERING: 64% of women sleep on the left side of the bed.
I'm a novice at SQL but maybe...
t_list_contents > t_order (join on customer_no) t_order > t_lineitem (join on order_no)t_lineitem > t_pkg (join on pkg_no)t_pkg > tr_pkg_type (join pkg_type on ID)
Would that work?
That did the trick. Thanks for the help!