Need help with a complex crosstab query

M

mscertified

I need a query to bring several tables of data together. The resulting query
will be the source for a number of user-written queries.
The main data tables are:
tblPackages
tblRules
tblPkgRuleXref (relates Packages to Rules, many to many))
tblPkgDates (refers to package and contains date type and date)
tblRuleDates (refers to rule and contains date type and date)

What I need is a single result set whose columns are Package and Rule and
then separate columns for each package date type and each rule date type. I
know there will be duplicated information but I'm not concerned about that. I
know I need some type of cross tab query.

David
 
Top