Re: Outer joins together with OR clause

From: David Schweisguth <davids_at_tracy.pangeasystems.com>
Date: 10 Jul 1998 14:52:13 GMT
Message-ID: <6o59qt$gbs$1@pornstorm.geo.net>

Thomas Blomqvist (tbt_at_idok.se) wrote:
: DO anyone have a way of writing a SQL statement without using cursors, to
: complete an outerjoin together with an OR clause.

: I have a relational table where i want to check the relation "both ways" in
: one SQL-statemanet.

Use a union.

Dave Schweisguth                              Work: davids_at_pangeasystems.com
Pangea Systems                                Home: dschweisguth_at_earthlink.net

Received on Fri Jul 10 1998 - 09:52:13 CDT

This message: [ Message body ]
Next message: David Schweisguth: "Re: Export of database blows Sun's 32bit file size limits"
Previous message: ryama_at_my-dejanews.com: "Re: timer function with PL/SQL?"
In reply to: Thomas Blomqvist: "Outer joins together with OR clause"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US