@EvanCarroll I notice you’re not in the SO moderator election again. You have failed me

They won't let me. F'kin wiener schnitzel sucking goose-steeping sieg-heiling MAGA posse keeps purging my nomination. Won't get their boot off my damn neck for a pico.

@Philᵀᴹ got a problem with it, email team+eat_the_poo_poo@stackoverflow.com

That's the most currently email address I have for the cabal.

Probably selling furniture and eating pizza, aimrite?

Morning all!

Morning

Morning

Morning all

Not much happening here this morning - thanks to SARS-CoV-2, I can get out for a walk most mornings (rain permitting) - I took a few photos about 300m from my fiancée's place - canal, swans - most pleasant!

The canal and the swans are nice and all, but those ducklings, ugh, they are just ugly!

@AndriyM They're not ducklings - how could they be, their parents are swans. They're cygnets and as cute as buttons. I'm told they make good eating as well, but it's illegal to hunt/kill swans here!

@Vérace Not ducklings? So what are you saying, that I'm telling you Andersen tales or something? :)

@AndriyM - I think you're telling fairy tales all right, trying to turn cygnets into ducklings! :-)

Guilty as charged

Though Andersen was first to do so

Fun fact: In our school production of the Hans Christian Anderson musical circa 1980 I played one of the ambassadors. My sole line was: "Call an intermission!"

In unrelated news, HP Zbooks have terribad keyboards.

@Vérace Do you actually find buttons, in general, cute?

Or just some, like [Esc] or [Ctrl]?

@mustaccio - could also say "cute as a bug's ear" - e.g. "Katydids — there are thousands of species — have the smallest ears of any animal, one on each front leg just below the “knee.”". Now, I've never seen a bug's ear, but I have seen buttons - I'm even paid buttons! :-) Common expression in English for something that's small and endearing!

I do get quite a frisson every time I push the [Esc] button!

Knees, of course, are another part of an insect's body that the English language has something to say about. At least, some insects are known to have very valuable knees.

@ConcernedOfTunbridgeWells All of them

The G5 Studio I have now seems to be better than the G3 but it's still crap

IT IS I, EVAN THE GREAT

How is everyone? Weathering the COVID-induced Great Depression, I hope? All gainfully employed still?

Trying to ask a question on the site, not sure how to phrase the question, which granted is a function of naming things which is hard.

or rather, phrase the Title

Doin' good.

Salary and hours back to normal. Products being released, service updates being released, turning around new features quickly, happy with my products. Wish there was a realistic place to go on vacation for a little getaway, but other than the oppressive heat making my morning walks untenable this week, things pretty good.

Ok, is there some fancy database term for what I want to do here: Select distinct values from Table1.A, join to Table2 on column B, but just get the "first" value for table2.C?

Sample data and expected output?

sqlfiddle.com/#!18/71946

I want from the tables in that Fiddle, I want distinct Foo.A, and just "first" Bar.C. So (A, 1), (B, 1)

SELECT Foo.A, MIN(Bar.C)
FROM Foo
LEFT JOIN Bar
  ON Bar.B = Foo.B
GROUP BY Foo.A

Is that what you want?

sqlfiddle.com/#!18/22205/1

Hmmm, @CadeRoux that is very close. If the first BAR record had been (1, 2), I would want that query to return (A, 2), (B, 1).

let me tweak the data a bit

sqlfiddle.com/#!18/fbee35/1

Given that data I want (A, 10), (B, 1)

note: the "ranking" of Bar.C is entirely artibrary in this case and I've been told it wouldn't change (e.g. to something like "first or last created record") but I give it 1/3 it will change down the road

That said, I can probably get away with using MIN or MAX if I need to, I'll talk to the PM

I really appreciate the help!

sqlfiddle.com/#!18/fbee35/9

Oh I just came to a similar place. I did this:

Yours seems a little neater, thanks!