Please or to access all these features

Add post

Watch this thread

Save thread

Start a new thread

Flip thread

Hide thread

My feed

Saved Active Unanswered threads

Getting started FAQ's

Unanswered threads Acronyms Talk guidelines

Hide shortcut buttons

Talk

Flip

Join the discussion and meet other Mumsnetters on our free online chat forum.

1 2

Join the discussion and meet other Mumsnetters on our free online chat forum.

Chat

Im stuck on a query

27 replies

StealthPolarBear · 29/05/2019 18:16

It needs to behave itself and do what I want

OP posts:

Thanks

Report

UrsulaPandress · 29/05/2019 18:17

::head tilt::

You ok hun?

Thanks

Report

StealthPolarBear · 29/05/2019 18:22

I'm fine. My query is a bitch.

OP posts:

Thanks

Report

Passthecake30 · 29/05/2019 18:26

Access?

Thanks

Report

HollowTalk · 29/05/2019 18:29

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

Thanks

Report

StealthPolarBear · 29/05/2019 18:34

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

OP posts:

Thanks

Report

Kleptronic · 29/05/2019 18:37

Ah yes. Sql is a bitch. Commiserations.

Thanks

Report

spaghettispool · 29/05/2019 18:38

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

Thanks

Report

StealthPolarBear · 29/05/2019 18:42

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

OP posts:

Thanks

Report

StealthPolarBear · 29/05/2019 18:43

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

OP posts:

Thanks

Report

goldierocks · 29/05/2019 19:18

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

Thanks

Report

StealthPolarBear · 29/05/2019 19:22

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

OP posts:

Thanks

Report

StealthPolarBear · 29/05/2019 19:22

I need to start drinking heavily

OP posts:

Thanks

Report

StealthPolarBear · 29/05/2019 19:36

I'm giving up :(

OP posts:

Thanks

Report

titchy · 29/05/2019 19:38

You need to add 'distinct'

Thanks

Report

StealthPolarBear · 29/05/2019 19:38

That's cheating!

OP posts:

Thanks

Report

titchy · 29/05/2019 19:43

Break it down into two then 'union' them?

Thanks

Report

KickBishopBrennanUpTheArse · 29/05/2019 19:48

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

It always works for me.

Thanks

Report

carnaval · 29/05/2019 20:00

Hive SQL is just beautiful

Thanks

Report

StealthPolarBear · 29/05/2019 20:00

I have hacked it. I feel dirty.

OP posts:

Thanks

Report

StealthPolarBear · 29/05/2019 20:07

Damn I've made it worse

OP posts:

Thanks

Report

PrincessMonacoOfKent · 29/05/2019 20:34

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!

Thanks

Report

StealthPolarBear · 29/05/2019 20:46

I have shower inspiration too :)

OP posts:

Thanks

Report

Kleptronic · 29/05/2019 23:17

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 :)

Thanks

Report

StealthPolarBear · 30/05/2019 06:46

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.

OP posts:

Thanks

Report

LittleLongDog · 31/05/2019 21:36

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

Thanks

Report

Flip

1 2

Please create an account

To comment on this thread you need to create a Mumsnet account.