Thanks so much for those who have explained Left Outer
Joins to me!  They have solved a bunch of problems that
I've been having!!!

Please answer one more question .....

Is it possible to do a LEFT OUTER JOIN on two tables,
i.e., I tried the following, with no success :

        SELECT *
        FROM tbl_a LEFT OUTER JOIN tbl_b, tbl_c
        ON (tbl_a.Who = tbl_b.What)
          AND (tbl_a.When = tbl_c.Where)
        ORDER BY tbl_a.Who

If someone could tell me how to do this, I think I
might actually finish this project!!!

Thanks for your help!

ryAn wIllIams

--
....................................................................
     Ryan Kenneth Williams           |      gt03...@prism.gatech.edu
Philippians 2:11  ...and that every tongue should confess that Jesus
                    Christ is Lord, to the glory of God the Father.

gt03...@prism.gatech.edu (Ryan K. Williams)  wrote

Ryan,

this one works for me!

Best regards

Michael

--------------------------- cut --------------------
SELECT Section.etno, Spares.price, Spares.pg, Spares.status,  
Spares.german, Spares.english, Spares.replaced
FROM Section s  LEFT OUTER JOIN Spares p ON s.etno=p.etno
WHERE section = :section;
--

Michael Suedkamp                                      m...@suedkm.franken.de

Ryan K. Williams <gt03...@prism.gatech.edu> wrote in article
<53643o$...@acmey.gatech.edu>...

This depends on the RDBMS you are using.  Most support only
one outer join per query, but some (Oracle?) support multiple
outer joins.

A common technique for circumventing outer join limitations is
the use of UNIONs, the support for which again depends on the
RDBMS in use.

Hope this helps,

Jolyon.