Announcements
SELECT I.manuf, I.name FROM Items I, Display D WHERE I.iId = D.iId AND D.sId = 12345The lesson to learn from the posted and worse solution is to never copy anything without thinking (it was about the only one I did as it was the last one, and I remember being a bit curious why it needs 3 tables instead of 2, but aren't we too often rushed at the end?!).
If this happened in an exams or a graded homework, you will get bonus points for the better solution.