Welcome! Log In Create A New Profile


advise needed

Posted by Nancy 
Announcements Last Post
Announcement SoC Curricula 09/30/2017 01:08PM
Announcement Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
Announcement School of Computing Short Learning Programmes 11/24/2014 08:37AM
Announcement Unisa contact information 07/28/2011 01:28PM
advise needed
September 18, 2007 03:41PM
I would like to be advised regarding the following (referring to Patrick, 2nd edition):

1) On page 311, line 3 from the bottom of the Result table: "format(my_date, 'dddd mmmm dd, yyyy' ) as my_date2", my question is why the column name of the result table view is MY_DATE instead of MY_DATE2?

2) On page 548, line 5 from the top: "from sec1306_fruits a, inner join..." for an inner join there is no comma after the table alias, so there should be a comma after the a ?

3) According to the Syllabus section of the Tutorial 101, chapter 14 (Outer joins) is excluded from our module syllabus, but in the chapter 17 and even in the assignment (assign 2 question 1.10) the left outer join and right outer join concepts are involved. What extent of these concepts should I grasp accordingly?
Sorry, only registered users may post in this forum.

Click here to login