It's UWAweek 47

help1402

This forum is provided to promote discussion amongst students enrolled in CITS1402 Relational Database Management Systems.

Please consider offering answers and suggestions to help other students! And if you fix a problem by following a suggestion here, it would be great if other interested students could see a short "Great, fixed it!"  followup message.

How do I ask a good question?
Displaying selected article
Showing 1 of 684 articles.
Currently 119 other people reading this forum.


 UWA week 36 (2nd semester, mid-semester break) ↓
SVG not supported

Login to reply

👍?
helpful
8:55pm Thu 5th Sep, Mengxi L.

yeah, I know what you mean. Our expected output based on the given data should be both IRN and IWS. But when we're intersecting the results of two queries,there are no common item_ids between these two, this part of the query is returning nothing,as a result, only IWS is being returned. You can have a try in your terminal. I think this issue with only getting IWS is likely due to the logic of EXCEPT and INTERSECT filtering out more than necessary.

The University of Western Australia

Computer Science and Software Engineering

CRICOS Code: 00126G
Written by [email protected]
Powered by history
Feedback always welcome - it makes our software better!
Last modified  8:08AM Aug 25 2024
Privacy policy