@JNat let me see if I can find a reasonably documented example of a cross-site query.

thanks!

I mean, I usually start with one of my recent queries, e.g. this one but without comments it's hard to grasp what's going on.

This one is probably better.

The part starting with -- Site details, cf. https://meta.stackexchange.com/a/359795/295232 is optional, that's just for formatting

There are other ways, e.g. here and linked posts, but this way (1. create temp table with results 2. build up SQL query with lots of unions 3. execute 4. profit!) was the easiest to understand for me.

I already knew about dynamic SQL, and the only thing new for me was the possibility to fully qualify tables, even in other databases. That's something SQL Server specific, other SQL dialects support it in a different way (or not at all).

I'll have a look later today and poke you if I need some further guidance — thanks again! ^_^

Good luck! I'm not here too often, it's mostly rene & Martin.

But feel free to ping me.

Curious if there are things that y'all would generally find useful if SEDE could be improved. It seems like having a built in way to search network-wide might be one of them - are there others?