Im stuck on a query

[StealthPolarBear]

It needs to behave itself and do what I want

::head tilt::

You ok hun?

I'm fine. My query is a bitch.

Access?

Oooh I love Access! Come on, tell us what you need to do.

Sorry was bickering about addressing cards
It's a sql query

Ah yes. Sql is a bitch. Commiserations.

Ooh I HATE Access 🙈 Go on, tell us! We might be able to help.

How dare you klep. I love sql. Just not this bit!

I can't tell you as it might be outing :)
Seriously, I'd have to explain the underlying structure, and what I'm trying to do which would take days and make no logical sense. Which I suppose is why I can't do it aargh

My query was misbehaving today. Turns out I needed a right outer join and not a left inner join. Obviously

I hope you then did the hokey cokey and turned around. Because that is what it's all about.

I need to start drinking heavily

I'm giving up :(

You need to add 'distinct'

That's cheating!

Break it down into two then 'union' them?

Write it all out on a piece of paper. Ideally with boxes and arrows.

It always works for me.

Hive SQL is just beautiful

I have hacked it. I feel dirty.

Damn I've made it worse

I tend to find a good night's sleep helps - the solution normally comes to me in the shower the next morning!

Either that or I email a friend who's much better at this sort of thing than I am and he has it solved in 5 minutes!

I have shower inspiration too :)

It's only a bitch because I'm bad at it, I never did get set theory. I do have a senior analyst who is stupendous at sql and all things data so pm me if you'd like a different set of eyes. We are extremely discreet also :)

Thank you but I think what I've hacked will do. I'm trying to create a hierarchy in sql where one doesn't exist, but without sub queries as the thing is already slow enough.

Opening this thread is like accidentally landing in a new country where you don’t speak the language.