I'm on it thanks.

I just want to make exactly the same selection of columns but with a year before. So I'm selecting three columns but I want to see six, three that are...

Looks good but how do I combine that with the other select?

I made the temp table in hope to join onto it but I can't.

Makes sense.

I don't really have anybody to "mentor" me but that's not a problem. What I am trying to do to really grasp these SQL concepts is read...

I’ve also heard about sub querying and using temp tables. When do you know when you need these?

Done thanks guys.

Ended up changing the whole thing.

Just thought I'd let you know, thanks again for your time Andy.

Guys thanks a lot for your help. I’ve spoken to management about this and it turns out the design is total crap and managers will be seeing to it tomorrow....

Andy leave it for now mate I'll talk to management because it's too messy I think. Maintaining this would be a nightmare too. I'll get back with clear info.

Sorry mate.

I've uploaded a txt file have a look at that. The previous one was a photo and it didn't show all the columns. Sorry.
Ignore Category 4...

Category 1 has 14, Category 2 has 56 and Category 3 has 15.

Not sure about Category 4 yet.

Will this still work?

Category 1 applies to EXTR_MILIMETRA columns. Category 2 may have 2 tables, same for three. Forget about four they haven't told me what to do with 4.
"I'm just struggling...

The CategoryId is in the table FIELDS_ACTIVATIONS where the FieldName is the column name of the data in the three tables...so common ground between the data and the categoryId is...

Morning Andy. I've posted a code update. It's category one. I've got exactly the same for CategoryTwo and CategoryThree each with their own columns.
Just need to get it all...

LOL.

I’ll go into work tomorrow, have a read through your answer and try to implement it. I’ll post back and let you know.

I still haven’t understood how it’s...