How do I show items dated 1 day from current date?

Question

Viewing 3 posts - 46 through 47 (of 47 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Looking at your code, this:

RIGHT OUTER JOIN dbo.EventDescription ED ON DEP.EventID = ED.EventID

should probably be this:

LEFT OUTER JOIN dbo.EventDescription ED ON DEP.EventID = ED.EventID

As this:

dbo.DefendantEventPros DEP is on the left side of the join. Make the change and see if that changes the output any.

Also, you may want to consider trying that join as an INNER JOIN to see what is returned as well.

simflex-897410 Hall of Fame Points: 3881 More actions · Answer 2

Thank you guys very, very, very much.

I am truly, truly grateful for everything.

simflex-897410 Hall of Fame Points: 3881 More actions · Answer 3

Yes, I made that change and of course there was no difference.

And I like what Lutz said, they asked for it; so what do they expect to get.

They were griping this morning and I just told them to review data entry because query is giving them what they asked for.

I have been blessed to get more than I asked for from you guys.

I think enough is enough.

Thanks soooo much (again and again) for all your kindness and patience.