Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2003
    Location
    Brazil
    Posts
    30

    Angry Unanswered: more on exam questions

    Is there any difference (other than column order in the output) in the results of the following queries ?

    1) SELECT c.class_name, i.last_name || ', ' || i.first_name InstructorName
    FROM instructor i RIGHT OUTER JOIN class c
    ON (i.instructor_id = c.instructor_id);

    2) SELECT c.class_name, i.last_name || ', ' || i.first_name InstructorName
    FROM instructor i RIGHT OUTER JOIN class c
    USING (instructor_id);

    The exam says the answer is 1, but I can't see the difference to the 2nd query. Using both syntaxes give me the same result, in an example I created.
    Last edited by 435 Gavea; 10-24-07 at 15:22.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •