@dave-3: that's indeed what I wanted 🙂

Thanks!

Ok, first of all safe driving and happy labor day 🙂

As you can see I'm already unioning the data, so I guess so far so good? So I would now...

Hi Lynn,

1 additional question: what if I want to combine these results with another similar table?

Besides location_views I also have table artist_views (which has the same column definition).

I know I...

Thanks! 🙂

I updated my question to return not last 30 days, but last 2 years. Now the data is correct again 🙂 Thanks!

Below are the insert statements and expected results.

@celko: thanks for your extensive explanation.

I didnt provide the full DDL for healthorganizations, companies etc.

Then you seem to want...

it was more that I left the room (because of my previous script I thought I had all the time ;), so I knew it was less than a minute..on...

I'm running it now...it works fine, just that (maybe I described that wrong), the campaignX column is filled with the prospectsincampaigns.prospectid, whereas it should be filled with prospectsincampaigns.notes

I made that...

Ok, I've placed a backup of the sanitized DB right here.

http://www.wunderwedding.com/files/sanitized.zip

Hopefully that is enough data to be able to create the correct queries?

Yes, I know that matching exactly is going to be nearly impossible.

So, spaces and dashes will be removed. That will have to do, anything which after that is still...

Ah I see now, thanks!

Ok, so talked to the customer and the last rule with the check on email is not really necessary...so only rule 1 and rule 2 would...

I dont understand how a row can be both in rule 2 and 3 when there's an explicit rule in 2: companyname is EXACT same and rule 3 is the...

Ofcourse, you scared the living **** out of me, but once again: thanks for noticing! Havent got around to check what the actual DB was yet, but better safe than...

Put the wrong db there..its offline now! Thank you so much for noticing!

Not sure what you mean, but if you think this is a homework assignment I'd have to disappoint you, I could then easily copy it from one of my fellow...