I have two tables, drivers and trips. I want to show which drivers are not used on a specific day on trips (based on a text box field on a form). I have a trip date field on trips to use for the comparison.
I don’t think i can do this with an unmatched query, and having trouble finding SQL i can use for this.
Any help is appreciated.
Hey guys, I’m certain this is something simple, and my brains just not quite turned on this morning. I have a switchboard that is adding a large white space underneath the 3 options that I currently have. I would like this white space to not be there.
Here is what it looks like: https://imgur.com/a/BX5dVb8
Here are my format settings: https://imgur.com/a/RQkjTe2
… Read More
Here’s a question for our coronavirus times that isn’t, “Can we hook up yet?” With my whole company working from home, I was recently in a small group Zoom meeting when one coworker, unaware that her camera was on, moved her phone/tablet/laptop and in the process panned across her bare chest. One of the other participants told her that her camera was on, and she immediately switched it off, with a lot of flustered apologies and oh-my-Gods. After a minute or
The amateur film buff in me won’t let this opportunity go by to correct the Portland Mercury when you get it wrong. The Bradley Cooper/Lady Gaga remake of “A Star Is Born” is actually the fourth remake, not the third as you stated. The first (non-musical) version was the Janet Gaynor “A Star Is Born,” then the Judy Garland/James Mason version, then the Barbra Streisand/Kris Kristofferson version. It’s not hard, Merc — get it right!
[Thanks for the heads up, anonymous amateur … Read More
The owners of every space where people gather have been refreshing their newsfeeds on the regular in recent weeks as the state slowly starts to reopen, wondering when and how they’ll be able to resume normal business. In this respect, Kickstand Comedy, the nonprofit theater that took over the Brody Theater downtown last year, is like every other concert hall, coffee shop, or bar: waiting patiently until they can safely throw open their doors and stage to comedy … Read More
If you’re stuck inside and desperately needing some top notch comedy, then the I, Anonymous Show (Livestream Edition) is for you! Here’s how it works: We get the funniest local and national comedians to riff and heckle the wildest, jaw droppingly wrong, and uncensored I, Anonymous submissions from the famous Mercury column, and in return you laugh yer buttz off!
The last two editions of the I, Anonymous Show were wildly funny and entertaining, so you truly do not … Read More
Here’s your daily roundup of all the local and national news about COVID-19. (Like our coverage? Please consider donating to the Mercury to keep it comin’!)
• According to the Oregon Health Authority, the state currently has 3,967 positive COVID-19 cases (that’s up almost 100 since Friday) and one additional death, for a total of 148. More than 98,000 (that we know … Read More
Fans of fashionable, locally made bathing suits will be sad to learn that Popina Swimwear—which has been in operation for the last 14 years—has been forced to permanently shutter their Pearl location due to financial complications from the pandemic. On a brighter note, their Hollywood location will reopen this Thursday, May 28.
“We’ve made it through some hard times, and this challenge has no doubt been the hardest,” said Popina founder Lulu Levenson in a press release … Read More
A married couple in an open relationship previously enjoyed glory holes at play parties. Then along came some COVID-19. But did that stop them? Hell no! They grabbed the kids’ old sheets and made a home glory hole. Now THAT’S what I’m talking about, America!
A man’s mother died when he was 13, and his father quickly remarried. He found a letter revealing that his father and step-mother had been having an affair before his mother died. Now what? His dad … Read More