Post reply

How to declare a outer join in diagramm

  • February 20, 2006 at 7:24 am

    #111911

    Hello,

    I have to declare outer joins on many tables. In DOL, they said :

    To add a join

    1. On the SQL tab, expand Tables, and select the table to which the join is added.
    2. Expand the table, right-click Joins, and click Add Join.
    3. In the New Join dialog box, select the name of the Destination Table for the join.
    4. Click Add.

      Note  If the Add button is not available, select a Destination Table.

    5. In the Join Condition dialog box, select the pair of fields to be joined, and click OK.
    6. Click Allow outer join if it is necessary to use this join as an outer join.

    But I don't have the Join/New Join Dialog Box. When I create a join, I just have the name of the relation, the two tables and there fields. After I have many options : Verifiy existing data after creation, Apply relation for Replication, Apply relation for Update and insert...

    How can I have this Dialog Box and how can I declare the outer join in my diagramm ? Is it an option to activate ?

    Thank's for your help.

    Gaelle

     

     

     

  • February 20, 2006 at 12:03 pm

    #622097

    'Joins' in diagrams are actual relations - a.k.a. Foreign Key Constraints.  What you are trying is not an option in database diagrams.

    Outer joins are for queries.  If you need to use outer joins when querying tables, you declare those in each query, not in the relationship between the tables.  You're reading the BOL topic for the visual query editor.

     

    Eddie Wuerch
    MCM: SQL

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply