help1402

It's UWAweek 18 (1st semester, week 9)

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 the 3 articles in this topic

Showing 3 of 105 articles.
Currently no other people reading this forum.

UWA week 16 (1st semester, week 7) ↓

Lab 3 Assistance (all 3)

10:30am Wed 17th Apr, ANONYMOUS

Hi, Have we learned all the required content to work on Lab 3 Q6? I noticed it wants us to merge attributes together and concatenate a string of either 'Code' or 'Type' and am not really sure how to proceed. Or am I overthinking it and it is a simple operator that we need to use? Cheers

Lab 3 Assistance (all 3)

2:39pm Wed 17th Apr, Mehwish N.

You need to use a union operator between the two queries. And then use orderby. Note: Do not attempt this through subqueries.

Lab 3 Assistance (all 3)

7:47pm Wed 17th Apr, Max B.

Is the sting 'code' and 'type' required in the results?

help1402 articles all ANNOUNCEMENTS recent articles login to post a new article help1402 topics from today and yesterday from the past week from the past two weeks ALL topics, most recent first	login chapter0 unitinfo research projects csforum csse-feedback csbreakdown cssubmit csmarks 1st semester help fora Computer Networks Data Structures and Algorithms Graphics and Animation Mobile and Wireless Computing Object Oriented Programming Open Source Tools and Scripting Software Requirements and Design Software Testing and Quality Assurance