/[cvs.andrew.net.au]/uni/COMP2400/q7.sql
ViewVC logotype

Diff of /uni/COMP2400/q7.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.2 by apollock, Wed Aug 11 01:30:29 2004 UTC revision 1.3 by apollock, Wed Aug 11 22:48:11 2004 UTC
# Line 1  Line 1 
1  TTITLE "COMP2400: Assignment 1: Question 7"  -- I have read the ANU Code on "Academic Honesty in Learning and Teaching",
2    -- and I declare that, except where appropriately attributed, the content
3    -- of the file I have submitted for this assignment is entirely my own
4    -- work. It has not been produced, in whole or in part, by another person.
5    -- (signed) Andrew Pollock 4137129
6    
7    TTITLE "COMP2400: Assignment 1: Question 7|Andrew Pollock(4137129)"
8    
9  COLUMN GRANDCHILD FORMAT A15 HEADING "Grandchild"  COLUMN GRANDCHILD FORMAT A15 HEADING "Grandchild"
10  COLUMN GRANDFATHER FORMAT A20 HEADING "Grandfather"  COLUMN GRANDFATHER FORMAT A20 HEADING "Grandfather"
# Line 14  AND mother.personid = p.motherid Line 20  AND mother.personid = p.motherid
20  AND p2.personid = grandchild.personid  AND p2.personid = grandchild.personid
21  AND grandfather.personid = p2.fatherid  AND grandfather.personid = p2.fatherid
22  AND grandmother.personid = p2.motherid  AND grandmother.personid = p2.motherid
23  AND (p2.personid = p.motherid OR p2.personid = p.fatherid)  AND (p2.personid = p.motherid OR p2.personid = p.fatherid) -- Brain haemorrhage occurred at this point
24  AND p.personid = '&1';  AND p.personid = '&1';
25    
26  EXIT  EXIT
Legend:
Removed from v.1.2  
changed lines
  Added in v.1.3
  ViewVC Help
Powered by ViewVC 1.1.22