How do I combine two different date fields from two different tables to report on them as one?
I'm working with Visual Studio 2010 Shell to write reports in Virtual Basic and then translate them into SQL. I have two date fields I'm working with: a guestroom consumption date from one table and an event consumption date from a second table. Both tables are left-joined to a third, common table. What I'm looking to do is run a parameter where I input a single date range and get the information for both guestrooms and events in one record. My problem has always been either repeating all event info for each guestroom consumption date or all repeating all guestroom information for each event date. Is there a function/operator I can use to do this? Does this make sense? Obviously I'm not the most savvy SQL user, but I'm eager to make this reporting solution work.