By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Query question - SQL syntax and joining multiple tables/queries

P: n/a
Hi all,

I'm trying to output a result set from some data as follows:

I have raw data with the following columns

Date,
Country,
System,
ID,
Revenue,
RecCount,
RPM,
Duration

I create 4 crosstab queries that give me

Country, System, ID as row headings
Date as the column heading
and one of Revenue, RecCount, RPM or duration as the value.

I only choose two dates so the columns are

Country, System, ID, Date1, Date2

for all the queries.

I then want to join then all up so I have

Country, System, ID, Revenue Date1, Revenue Date2, RecCount Date1,
RecCount Date2, RPM Date1, RPM Date2, Duration Date1, Duration, Date2

I'm struggling to make the final query work... any thoughts?

Thanks,

Rob.

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.