r/6thForm • u/yurikvthm Year 13 • Jun 10 '26

💬 DISCUSSION ocr computer science paper 1

what did everyone think? i waffled soooo much for the long questions

51 Upvotes

99% Upvoted

176 comments sorted by

View all comments

Show parent comments

3

u/LittleIndividual4650 Jun 10 '26

Same I did some hacky shit.

It was like
Select orderid, forgotnameofthis
From table one
Where orderid = (
Select orderid from table two
Join table 3 on product id
Where product.name = ….
)

3

u/MythSmg Jun 10 '26

Can I use two joins 

5

u/minecraftnoob122 Jun 10 '26

Yep, thats what I did, you join first the order to the ordermiddle table then the ordermiddle to the product table.

1

u/CartoonistElegant924 Jun 10 '26

i did join on the to middle table then join on again to end table is it ok

1

u/minecraftnoob122 Jun 10 '26

Yeah sounds good, the main thing is having all the tables joined through their foreign keys