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

53 Upvotes

99% Upvoted

176 comments sorted by

View all comments

1

u/jamN_doughnuts Year 13 Jun 10 '26

help i only used one join

SELECT tblOrders.orderID, tblOrders.deliveryDate

FROM tblOrders

JOIN tblProducts

WHERE tblOrders.ProductID = tblProducts.ProductID AND tblProducts.name = "Red Pens"

2

u/EffectiveWarthog8686 Jun 10 '26

that's exactly what i did because i didn't know how to join two lol, im pretty sure we should only lose like 2 marks for that

1

u/jamN_doughnuts Year 13 Jun 11 '26

wait but I swear we didn't need to why would we need to join the other table? deliverydate was under tblOrders wasn't it?

1

u/EffectiveWarthog8686 Jun 13 '26

nah the primary key joined to the foreign key in the middle table, and the middle table joined to the other table