Re: Join syntax question

From: Barbara Boehmer <baboehme_at_hotmail.com>
Date: 15 Jun 2005 06:00:22 -0700
Message-ID: <1118840422.003289.292430@g43g2000cwa.googlegroups.com>

scott_at_ORA92> SELECT * FROM books
2 /

ID TITLE
---------- ----------

         1 title1
         2 title2
         3 title3

scott_at_ORA92> SELECT * FROM authors
2 /

ID BOOKID NAME
---------- ---------- ----------

        10          2 name2
        20          3 name3
        20          3 name4

scott_at_ORA92> SET NULL NULL
scott_at_ORA92> SELECT b.title AS book_title, MIN (a.name) AS author   2 FROM books b, authors a
  3 WHERE b.id = a.bookid (+)
  4 GROUP BY b.title
  5 /

BOOK_TITLE AUTHOR
---------- ----------

title1     NULL
title2     name2
title3     name3

scott_at_ORA92> Received on Wed Jun 15 2005 - 08:00:22 CDT